DATA Step, Macro, Functions and more

Adding data from excel to existing SAS dataset

Reply
Contributor
Posts: 35

Adding data from excel to existing SAS dataset

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

 

 

 


LA.PNG
Super User
Super User
Posts: 7,039

Re: Adding data from excel to existing SAS dataset

So what is the question?

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

Ask a Question
Discussion stats
  • 1 reply
  • 157 views
  • 0 likes
  • 2 in conversation