Re: PROC FREQ Outputting with a zero count

momi · Posted 05-30-2017 04:42 PM

Hi,

How can I leave a zero count when outputting the count from PROC FREQ?

For example, here is the result from PROC FREQ.

When I use an OUT option, the output only contains nonzero count (below).

Instead above, I want to have all counts including zeros (below).

Can anyone help on this?

Thanks!

mkeintz · Posted 05-30-2017 05:17 PM

Use the SPARSE option on the tables statement:

proc freq data=have noprint;

tables row * col / norow nocol nopercent sparse out=want;

run;

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

momi · Posted 05-31-2017 10:36 AM

The SPARSE option works!

Thanks!!

PROC FREQ Outputting with a zero count