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.

sas-innovate-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

Register 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
  • 908 views
  • 0 likes
  • 2 in conversation