Hi
I have a sample dataset as below with many records and tried the following code to get zero counts with required combinations , but am getting all the possible combinations along with the relevant group, even though those records doesn't belong to that group.Is there anyway I can get the desired output as stated below
proc format; value $sc(notsorted) "low"="low" "medium"="medium" "high"="high"; run;
data test; infile cards; input cat $ code $ score $; cards; c1 a11 low c1 b11 medium c2 e12 low c2 h13 medium ; run;
data test2; set test; format score $sc.; run;
proc summary data=test2 nway completetypes; class cat code score/preloadfmt; output out=test_cnts; run;
Result:
I need the output only with rows of respective by group, as below
Desired output:
c1 a11 high 0
c1 a11 low 1
c1 a11 medium 0
c1 b11 high 0
c1 b11 low 0
c1 b11 medium 1
c2 e12 high 0
c2 e12 low 1
c2 e12 medium 0
c2 h13 high 0
c2 h13 low 0
c2 h13 medium 1
Highly appreciate your input
Thanks
... View more