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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.