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
where 0 <EDUC< 90
grouped by SERIAL