Help using Base SAS procedures

creating mean variable by groups

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 6
Accepted Solution

creating mean variable by groups

I apologize in advance if this question is silly, but how do I create a mean variable by groups. Take the below table for example, I want to calculate a Var2 such that for the first 3 observations, Var2 is the mean(Var1 of the first 3 obs), and Var2 for the next 7 obs is mean(Var1 from id=4 to id=10). ie, to get from Table 1 to Table 2. Thank you!

Table 1

IDGroupVar1
1A1
2A1
3A4
4B3
5B3
6B3
7B3
8B3
9B3
10B10

Table 2


IDGroupVar1Var2
1A12
2A12
3A42
4B34
5B34
6B34
7B34
8B34
9B34
10B104

Accepted Solutions
Solution
‎02-16-2012 03:06 AM
Super User
Posts: 5,437

creating mean variable by groups

SQL with a GROUP BY that is remerging the statistic with the original query:

select group, var1, mean(var1) as var2

from table1

group by group;

Data never sleeps

View solution in original post


All Replies
Solution
‎02-16-2012 03:06 AM
Super User
Posts: 5,437

creating mean variable by groups

SQL with a GROUP BY that is remerging the statistic with the original query:

select group, var1, mean(var1) as var2

from table1

group by group;

Data never sleeps
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

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