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

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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
  • 1207 views
  • 2 likes
  • 2 in conversation