I am basically trying to group by 2 variables and perform a proc sql mean, however my group by won't work for the following reason : here's an example of what I am trying to get (Assuming the data here is sorted properly)

Now I know that this is not how the mean functions work so I've tried thinking about ways to resolve my issue and I've found that this would work :

However I don't know how I could obtain that. I have tried

data want;
set have;
count + 1;
by User Var X;
if first.User then count = 1;
run;

However this does not seem to get the trick done. Any ideas on how to resolve this ?

Thanks for reading !

1 Answer

Like this?

data have;
input user $ varx value average;
datalines;
A 5 150 200
A 5 250 200
A 10 500 500
A 10 500 500
A 10 500 500
A 5 50 50
A 5 50 50
A 20 10 10
;
data want; set have; by user varx notsorted; if first.varx then count + 1;
run;

0

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.