BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
ldavis020
Fluorite | Level 6

Hello! I'm attempting to create a new variable that assigns the mean in period 2 to period 1 for each group. Better to explain with the data. 

 

This is what I have: 

data have;
input group period mean;
datalines;
1 1 10
1 2 20
2 1 33
2 2 22
3 1 21
3 2 34
4 1 33
4 2 32
;
run;

This is what I want:

data want;
input group period mean meanp2;
datalines;
1 1 10 20 
1 2 20 20
2 1 33 22
2 2 22 22
3 1 21 34
3 2 34 34
4 1 33 32
4 2 32 32
;
run;

 

1 ACCEPTED SOLUTION

Accepted Solutions
ldavis020
Fluorite | Level 6

Answered my own question. Sorry thanks!! 

 

For references the solution is: 

 

data p2; set have;
meanp2=mean;
where period=2;
run;

data want; 
merge p2 have;
by group;
run;

 

View solution in original post

1 REPLY 1
ldavis020
Fluorite | Level 6

Answered my own question. Sorry thanks!! 

 

For references the solution is: 

 

data p2; set have;
meanp2=mean;
where period=2;
run;

data want; 
merge p2 have;
by group;
run;

 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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
  • 473 views
  • 0 likes
  • 1 in conversation