topic Re: N statistic for a character variable in SAS Procedures

N statistic for a character variable

ddutton325 — Thu, 10 Oct 2024 22:44:05 GMT

HI y'all,

I know that there is a way to get either or both of PROC MEANS or PROC SUMMARY to give me a simple count of a character variable by a couple of CLASS variables. I am pretty sure that before PROC MEANS and PROC SUMMARY basically became one and the same, that SUMMARY supported that, while MEANS did not. but so far, my attempts to get this elusive number have been unsuccessful.

Does anyone know how to do this? I really do not want to resort to DATA step or PROC SQL.

thanks,

Donna

Re: N statistic for a character variable

PaigeMiller — Thu, 10 Oct 2024 23:14:05 GMT

PROC FREQ is the tool you want. It should be your first choice whenever you have to count things.

Re: N statistic for a character variable

Tom — Fri, 11 Oct 2024 02:17:21 GMT

Syntax should be the same.

proc summary data=sashelp.class;
 class sex ;
 output out=want ;
run;
proc print;
run;

Re: N statistic for a character variable

Bala_Saladi — Sat, 12 Oct 2024 21:28:32 GMT

Try to get frequency through proc means:-

proc means data=sashelp.class n;
class name sex;
output out=means_out (DROP=_type_ _freq_ );

data means_out;
set means_out;
where _STAT_='N';
run;
proc print;
run;

Re: N statistic for a character variable

Rick_SAS — Sun, 13 Oct 2024 09:26:28 GMT

Use the TABLE statement in PROC FREQ. You can add the OUT= option if you need the counts in a data set.

proc freq data=sashelp.class;
   table sex / out=FreqOut;
run;