topic Re: How do I hold a place in a table where there is no value? in SAS Procedures

How do I hold a place in a table where there is no value?

deleted_user — Wed, 05 Aug 2009 15:25:22 GMT

For example, here is my code:

proc freq data=basedata1;
table satcat*apply/nocol norow nopercent missprint;
where hold=1 and reside=1;
format satcat satcat.;
run;

Output:

Table of SATCat by APPLY
SATCat APPLY(apply) Total
1.00
1000-1090 8 8
<1000 165 165
Total 173 173

What I want to do is have the output table also include the other values of the variable SATcat in which there are no observations(in this particular subset of the data) so that the output looks something like this:

Table of SATCat by APPLY
SATCat APPLY(apply) Total
1.00
>1200
1100-1190
1000-1090 8 8
<1000 165 165
Total 173 173

(Other tables I produce use similar variables and subset the data differently so that I end up with observations in all the levels of SATcat and I'm trying to make all of my tables look the same.)

Any ideas? I would also love to know if this can be done in PROC Tabulate as well.

Re: How do I hold a place in a table where there is no value?

Cynthia_sas — Wed, 05 Aug 2009 15:56:33 GMT

Hi,
You're on the right track, asking about PROC TABULATE. TABULATE, REPORT and MEANS are all procedures that support the use of the PRELOADFMT option -- which allows you to tell the procedures what list of values you'd LIKE to see in the output, even if some of the list does not appear in the data. PROC FREQ does -not- use the PRELOADFMT option.

Some prior forums postings on the topic of PRELOADFMT are:
http://support.sas.com/forums/thread.jspa?messageID=19957䷵
http://support.sas.com/forums/thread.jspa?messageID=14459㡻
http://support.sas.com/forums/thread.jspa?messageID=4872ገ

cynthia

Re: How do I hold a place in a table where there is no value?

deleted_user — Wed, 05 Aug 2009 16:02:43 GMT

Thank you, I will look into PRELOADFMT.

Re: How do I hold a place in a table where there is no value?

deleted_user — Wed, 05 Aug 2009 16:19:03 GMT

I tried using PRELOADFMT for a proc tabulate procedure and it worked great, thank you! Anyone have any ideas on doing something similar using proc freq?