Status:Closed    Asked:Jan 13, 2015 - 10:44 PM

Follow up to highest education IHIS question


I greatly appreciate your help in answering my questions on IHIS. I have a follow-up question to your answer on my "IHIS: Highest family educ variable and Family number variable" question.

You mentioned that it was quite easy to obtain the max education number from EDUC, and I would really appreciate if you could elaborate on this. I have been having difficulty with creating a data table from the IHIS data set where each SERIAL number would only have the max education number under the education column.

I have tried to use a proc SQL code, as shown below - however, the table that is produced from the code contains strange SERIAL numbers (for example, in the original dataset it appeared that the smallest SERIAL was 8 - but in the new dataset the smallest SERIAL was 1) and the proper SERIAL numbers did not contain the max education value based on the previous data set.

Thank you very much!

proc SQL ;

createtable IPUMS.B asselect SERIAL, EDUC

from IPUMS.ihis_00020

where 0 <EDUC< 90

grouped by SERIAL

having EDUC=max(EDUC);

Do you have the same question? Follow this Question

Staff Answer




There are likely multiple ways to retrieve the maximum EDUC value by SERIAL. I used the following code:

proc means noprint max nway missing;
class serial;
var educ;
output out=educ_max (drop=_type_ _freq_) max=;

I hope this helps.


Jan 14, 2015 - 09:37 AM

Report it


Generate family weights for summary statistics for families (not people or ho...
In IHIS what does "not ascertained" mean for BIDIEV, PIPEV etc in 2000 and 20...
Why are not all the "not in the labour force" categories filled for the EMPST...
I am getting strange numbers for NIU persons in the sixties, especially 1962-...
Children living alone?
Login   |   Register

Recently Active Members

View More »

Share |