Add excel data to existing SAS dataset

[mayasak]

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

[PGStats]

What have you tried so far?

[ballardw · Accepted solution]

First step would be import the Excel data into SAS.

The Merge (datastep) or Join (Proc Sql based on the value of the Fips code.

Either datastep or Proc Sql solution would allow doing the calculation in the same step.