Date: Mon, 12 Mar 2001 13:15:37 -0000
Reply-To: Richard Paterson <RichardP@OCS-CONSULTING.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Richard Paterson <RichardP@OCS-CONSULTING.COM>
Subject: Proc Tabulate : V8 Using PRELOADFMT and CLASSDATA
Content-Type: text/plain; charset="iso-8859-1"
I am trying to create a table of events occuring within a given month. There
should be 1 column for each day of the month. For this I have created a
format representing each day of the month to be used with PRELOADFMT. So far
so good, except since I must specify PRINTMISS when using PRELOADFMT, rows
which do not exist are being displayed, e.g where sex=male, event =
"Pregnancy test". This is obviously incorrect. I then tried creating a
dataset with only the valid class combinations and using a CLASSDATA
statement. It now appears that PRELOADFMT is now being ignored and only days
represented in the data are being shown. I could add all possible date
combinations to the CLASSDATA dataset. But then I am back to the V6
situation where I had to ensure that all classes were represented in the
dataset before creating the table. Am I missing something here ? What use is
the PRELOADFMT statement in this situation ?
Any information is much appreciated.