Proc Freq and null/zero frequencies

[Paul_NYS]

Hi

I have a data set that I run several frequencies and simple percents on which lead to an output similar to the below example file. One of the variables that I include in the many frequencies is an Exit Month time frame. For the Exit Month variable, I included a check for a 0 month option, but there are no values for 0 in the entire data set. Is there any way to include a 0 Exit Month value in the output from these SAS routines equaling a count of 0?

http://www.nycourts.gov/surveys/cwcip/procFreqOutput.zip

Below is one of the many frequencies that I run on this data set:

proc freq data=s1ageshort noprint;

  tables startyear*exit*agecat4*exitMonthCategory/out=s1ageshorttest sparse;

run;

Paul

[data_null__]

You need a PROC that allows the creation of something from nothing.  SUMMARY/MEANS and TABULATE are two.  For SUMMARY/MEANS look at documentation concerning the CLASSDATA option and or PRELOADFMT.  You can get to the same place by either method.

[Cynthia_sas · Accepted solution]

Hi:

PROC REPORT and TABULATE also support PRELOADFMT (with TABULATE, you need PRINTMISS and with REPORT, you need COMPLETEROWS option). TABULATE and MEANS will both use CLASSDATA. Check the documentation for which one applies to your situation.

  By way of explanation, PROC FREQ, with the SPARSE option will put a row for F age 16 into the FREQ output for SASHELP.CLASS because AGE 16 is in the data, but only for M age 16. However, AGE 10 is NOT in the dataset -- at all -- so the SPARSE option will not put AGE10 in the output. That is the kind of thing that REPORT and TABULATE and MEANS/SUMMARY will do.

cynthia

[Paul_NYS]

Thanks Cynthia. That explains it then.