Help using Base SAS procedures

proc summary issue

Reply
N/A
Posts: 0

proc summary issue

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;

Thanks for all your help.

Pappu.
Super User
Posts: 5,254

Re: proc summary issue

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
Ask a Question
Discussion stats
  • 1 reply
  • 108 views
  • 0 likes
  • 2 in conversation