Hello All
I am using the following code to generate a count meaning for each Plan there are 1 or more Households attached and for each household there are 1 or more accounts attached to it.
The following proc summary is iving me the same count for all the 3 variables - plans, households and accounts.
Question
Since N in the code signifies count - How would I be able to use a count-distinct for just the plans and a normal count for the remaining 2 variables?
Code
proc summary data = workpks.temp13 N;
var Plan
Household
Account
;
class RSPNSBY_CNTR_ID;
output out = workpks.temp13_smry N= Plan Household Account;
run;
I'm not sure, but I don't think that summary offers the count distinct construct.
So an advice is to go for proc sql instead where this can easily ca be achieved.
/Linus
Data never sleeps
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.