topic Re: Add excel data to existing SAS dataset in SAS Programming

Add excel data to existing SAS dataset

mayasak — Fri, 15 Jul 2016 18:10:43 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: Add excel data to existing SAS dataset

PGStats — Fri, 15 Jul 2016 19:17:17 GMT

What have you tried so far?

Re: Add excel data to existing SAS dataset

ballardw — Fri, 15 Jul 2016 19:48:56 GMT

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.