proc summary issue

[deleted_user]

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.

[LinusH]

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