DATA Step, Macro, Functions and more

PROC FREQ Outputting with a zero count

Reply
Contributor
Posts: 21

PROC FREQ Outputting with a zero count

 

Hi,

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

For example, here is the result from PROC FREQ.

 

  Yes No
A 40 0
B 30 20
C 0 30

 

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

 

A Yes 40
B Yes 30
B No 20
C No

30

 

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

 

A Yes 40
A No 0
B Yes 30
B No 20
C Yes 0
C No 30

 

Can anyone help on this?

 

Thanks!

 

Valued Guide
Posts: 797

Re: PROC FREQ Outputting with a zero count

Use the SPARSE option on the tables statement:

 

proc freq data=have noprint;

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

run;

Contributor
Posts: 21

Re: PROC FREQ Outputting with a zero count

The SPARSE option works!

Thanks!!

Ask a Question
Discussion stats
  • 2 replies
  • 99 views
  • 1 like
  • 2 in conversation