Hello, I have the following data set and need to summarize in the manner of the following code. However, instead of outputting to total for the variable PS, I need the distinct total only. proc means data=WORK.TEST noprint; by R TC RN SS SH; var PS; output out= TEST1 sum (E)=E_F n(PS)=NB_PS; run; RN E TC R SS SH PS 1 707 5003 A02 SS 2028106601 1 698 5003 A02 SS 2028106601 1 1119 5003 A02 SS 2028106601 1 2099 5003 A02 2028612941 1 1370 5003 A02 2024667991 1 865 5003 A02 2028221751 1 3026 5003 A02 2028221751 1 1008 5003 A02 2025744721 1 604 6003 A09 SH 2027282411 1 1285 6003 A09 SH 2027282411 1 2107 6003 A09 2025877621 1 854 6003 A09 2025250411 1 955 6003 A09 2024224891 1 502 6003 A09 2022288221 So instead of getting the output: R TC RN SS SH E_F NB_PS A02 5003 1 SS 8368 3 A02 5003 1 2524 5 A09 6003 1 SH 1889 2 A09 6003 1 4418 4 I need the output: R TC RN SS SH E_F NB_PS A02 5003 1 SS 8368 1 A02 5003 1 2524 4 A09 6003 1 SH 1889 1 A09 6003 1 4418 4 Thank you for any help!
... View more