Date:         Tue, 27 Jun 2000 22:50:31 GMT
Reply-To:     Nelson Harrison <nelson@MNSI.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nelson Harrison <nelson@MNSI.NET>
Organization: http://extra.newsguy.com
Subject:      Adding a Missing Field
Content-Type: text/plain; charset=us-ascii

I'm sure how to do the following

ORIGINAL dataset

USM     EVENT
1             MEXC
1             FUSO
2             FUSO
3             MEXC
etc.

FINAL dataset

EVENT   _1    _2   _3   etc
MEXC      1       0     1
FUSO      1       1     0
etc.

The problem I have is that I have Crystal reports written that are
looking for all the possible USMs (25 in total).  One valid value of
the USM is 999 which is used for unknown.  In the perfect world there
shouldn't be any 999's.  But then I would need to add the field _999
to the FINAL dataset so that my report will work.  How to do I check
that all the USM values are there and if not add the missing ones.

Thanks

Nelson