07-15-2016 02:09 PM
I have a SAS data set which has data for "estimated population count" for 33 counties "Fipscode:county fipscode, 2-digit numeric"variable, years 1990-2016. I have to add a variable named ALAND10 (from excel) which has a land area for each of the fipscode county variable in SAS (33 counties).
Later I need to calculate population density from the land area and population estimates. I've attached a SAS data and excel clip.