BookmarkSubscribeRSS Feed
mayasak
Quartz | Level 8

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
1 REPLY 1
Tom
Super User Tom
Super User

So what is the question?

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

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore Now →
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1391 views
  • 0 likes
  • 2 in conversation