Adding data from excel to existing SAS dataset

mayasak — Fri, 15 Jul 2016 18:09:05 GMT

Hi,

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.

Thanks

Re: Adding data from excel to existing SAS dataset

Tom — Sat, 16 Jul 2016 14:22:50 GMT

So what is the question?

Read the new data into a SAS dataset and then merge the two datasets by the FIPS code.

topic Adding data from excel to existing SAS dataset in SAS Programming

Adding data from excel to existing SAS dataset

Re: Adding data from excel to existing SAS dataset