topic Re: Proc freq table option SPARSE in SAS Procedures

Proc freq table option SPARSE

deleted_user — Tue, 30 Mar 2010 22:34:13 GMT

I am creating cross tabs by State. I know some of these cross tabs will be zero, but I want to see them and keep them in the output data set so i am using the option SPARSE. I am running into a problem where the output is not keeping all of the zero cross tabs. In particular, in my case I have two cross tabs with zero values but the output is only keeping the first one. See sample code below.

Anyone have any suggestions as to what I'm doing wrong? Has anyone else had this problem?

PROC FREQ DATA=one;
By State;
TABLE X1*X2 / out=test sparse; weight Z;
RUN;

Re: Proc freq table option SPARSE

sbb — Tue, 30 Mar 2010 22:52:08 GMT

From the SAS PROC FREQ DOC - you need the LIST option as well, I believe.

Scott Barry
SBBWorks, Inc.

http://support.sas.com/documentation/cdl/en/procstat/63032/HTML/default/procstat_freq_sect010.htm#procstat.freq.freqsparse

Re: Proc freq table option SPARSE

deleted_user — Tue, 30 Mar 2010 23:06:50 GMT

I gave it a try and it did not help. It looks to me like you only need either LIST or OUT= for sparse to work. I am having a weird situation because it appears to work for some but not for all. I am also running the same program for other years and I haven't had any problem.

Re: Proc freq table option SPARSE

sbb — Tue, 30 Mar 2010 23:53:15 GMT

Suggest you share an actual data-sample, both INPUT and OUTPUT, for another perspective from forum subscribers. Ideally the data would be pasted directly from your SAS log/list output, not hand-keyed.

Scott Barry
SBBWorks, Inc.