Question

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

Follow up to highest education IHIS question

Hi,


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

avatar

Joe_Grover

Staff

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


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


I hope this helps.

 

Jan 14, 2015 - 09:37 AM

1
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

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 |