topic Re: proc sql count distinct in SAS Programming

proc sql count distinct

SASdevAnneMarie — Tue, 29 Nov 2022 14:08:30 GMT

Hello Experts,

Do you know please, how to write the proc sql count distinct statement with condition to have this output :

Input :

Output :

Thank you !

PaigeMiller — Tue, 29 Nov 2022 14:19:45 GMT

UNTESTED CODE

proc sql;
    create table want as select count(*) from have group by week,data;
quit;

If you want tested code, please provide the data as text as SAS data step code (instructions) and not as screen captures.

You can also do this via PROC FREQ

proc freq data=have;
    tables week*data/nocol norow nopercent;
run;

Kurt_Bremser — Tue, 29 Nov 2022 14:22:48 GMT

Please do never (as in NEVER) supply example data in pictures. Always (as in ALWAYS) use a data step with datalines, posted in a code box.

Because of the lack of usable data, this code is untested:

proc report data=have;
column week n,data;
define week / group;
define data / "" across;
define n / "";
run;