SAS - Increment a counting variable increasing whenver other variable in a group changes

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;