Date:         Fri, 12 Jul 1996 10:50:04 PDT
Reply-To:     TWB2%Rates%FAR@GO50.COMP.PGE.COM
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         TWB2%Rates%FAR@GO50.COMP.PGE.COM
Subject:      Re: Forcing SAS to output all categories of a variable, even if
Comments: To: anne@RTI.ORG

In many PROC's, the MISSING option will do this.  I am not referring to
the option statement which specifies a print value for missing values,
but to an option available in several PROC's:
 
PROC FREQ DATA=MINE.ALLMINE;
   WHERE LASTDATE LT '01JAN94'D;
   TABLE RACE*AGECAT / MISSING;
RUN;
 
By the way, I almost always use the LIST option on FREQ table requests
to get a format like your example below.  I did not code the LIST option
on this sample because I did not want readers to think the sequence
"LIST MISSING" was a single option.
 
Tim Berryhill - Contract Programmer and General Wizard
TWB2@PGE.COM
Frequently at Pacific Gas & Electric Co., San Francisco
The correlation coefficient between their views and
my postings is slightly less than 0
----------------------[Reply - Original Message]----------------------
 
Sent by:"Theisen, Anne C." <anne@RTI.ORG>
 I periodically have subsets of data where a category on a variable will
be missing. I need to output this category even if it is missing. Is
there a way to do this.  For example, RACE, has 1=white 2=black
3=hispanic 4=other. There are times when I have no "others" in the
sample but I still need to see that "other" was and option...
 
                white   25      25.0%
                black   25      25.0%
                hisp    50      50.0%
                other     0       0.0%
 
=====================================================================