topic Re: PROC FREQ Outputting with a zero count in SAS Programming

PROC FREQ Outputting with a zero count

momi — Tue, 30 May 2017 20:42:18 GMT

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 — Tue, 30 May 2017 21:17:30 GMT

Use the SPARSE option on the tables statement:

proc freq data=have noprint;

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

run;

momi — Wed, 31 May 2017 14:36:22 GMT

The SPARSE option works!

Thanks!!