You may do the exercises below
on another computer if the unavailability of the VRDC is a problem.
Basic SAS exercises
Consult the
documentation for the Census 2000 Public Use Microsamples (Census 2000 pums.pdf)
Write a SAS program to separate
the household records from the person records in pumsbxak.sas7bdat. Index
the household record file by the unique record identifier on that file (serialno).
(We're using Alaska in this example because it is small.)
Write a SAS program to extract
the male or female (your choice) householders from the person record file.
Add family total income to the person records. (Try to do this using your
index for the household record.)
Construct the median family income
for males or females (same choice as above) by PUMA (use the variable puma5).
Be careful to select the correct samples and the correct weights. Save the
result to a SAS file.
Construct a person-level file
that contains median family income for male (or female) householders in the
PUMA. What is the correlation between family income for the males (or females)
and median family income in the PUMA for householders of the same sex.