proc summary issue

deleted_user — Thu, 07 May 2009 18:26:32 GMT

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.

Re: proc summary issue

LinusH — Fri, 08 May 2009 06:32:50 GMT

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

topic Re: proc summary issue in SAS Procedures

proc summary issue

Re: proc summary issue