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
Comments: To: SAS-L@LISTSERV.VT.EDU
Content-Type: text/plain; charset="iso-8859-1"

Hi folks,

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.

Regards

Richard Paterson