I have created a SAS dataset with information from 2000 on African American/Black women living in North Carolina. I want to use this data set to compute the median and average income for this group of people within this geographic region. When I viewed the datatable it showed 0s, 9s , and N/A in the values for all the income variables I selected form the IPUMS website: INCEARN_F, INCEARN_HEAD_F, INCTOT_F,INCTOT_HEAD_F, INCWAGE_F, and INCWAGE_HEAD_F. It also shows me that the income variables I identify in a proc univariate program are not found.
Log Print out:
596 PROC UNIVARIATE data=IPUMS.usa_00002_f;
597 VAR INCEARN_F INCEARN_HEAD_F INCTOT_F INCTOT_HEAD_F INCWAGE_F INCWAGE_HEAD_F;
ERROR: Variable INCEARN_F not found.
ERROR: Variable INCEARN_HEAD_F not found.
ERROR: Variable INCTOT_F not found.
ERROR: Variable INCTOT_HEAD_F not found.
ERROR: Variable INCWAGE_F not found.
ERROR: Variable INCWAGE_HEAD_F not found.
How do I generate a dataset from this website that has the data to answer my question for either the year 2000 and/or 2010?