BookmarkSubscribeRSS Feed
NonSleeper
Quartz | Level 8

The input data looks like below: 

 
State County HH Var
1 1 1 1
1 1 2 2
1 1 3  
1 2 1 4
1 2 2 5
1 3 1 6
2 1 1 1
2 1 2 2
2 2 1 3
2 3 1 4
2 3 2  

 

The set of 3 variables state, county, and households (HH) specifies unique codes for observations.

 

The variable Var is, say, a characteristic of households and it has missing data. My question is: How can I replace those missing observations with the mean values of households of the same county?

 

The output data should look like:

 

State County HH Var
1 1 1 1
1 1 2 2
1 1 3 1.5
1 2 1 4
1 2 2 5
1 3 1 6
2 1 1 1
2 1 2 2
2 2 1 3
2 3 1 4
2 3 2 4

 

 

2 REPLIES 2
NonSleeper
Quartz | Level 8

After some search, it seems quite straightforward with PROC STANDARD. Sorry for bringing this up, but for those who are as novice:

 

proc standard data=have replace;

var Var;

by state county;

run;

LinusH
Tourmaline | Level 20
Thanks for sharing your solution!
Data never sleeps

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 859 views
  • 2 likes
  • 2 in conversation