Date:         Fri, 14 Oct 2005 15:16:45 -0400
Reply-To:     Dianne Rhodes <RHODESD1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Dianne Rhodes <RHODESD1@WESTAT.COM>
Subject:      Re: Proc transpose questions
Comments: To: "Fehd, Ronald J" <rjf2@CDC.GOV>
Content-Type: text/plain; charset="us-ascii"

> > From: Wainwright, Andrea
> > OK, two issues.  One, my ID variable is numeric and contains nulls,
> > and I need null as a column after being transposed.
> >
> > My inelegant option is to convert the field from numeric to
> character
> > and replace '.' with 'NULL' but I was wondering if there
> was an option
> > I am missing or a better way to do it.
>
To which the Macro Maven boldly replied:

> uh, you have an id and you don't know who/what it is?
> recommendation: delete
>
> where ID ne .

My, my.  Don't forget the old adage "one man's error is another man's
data."  Maybe she needs to account for her missings.  Sometimes the ID
variable might be something like, say ICD9 code that is missing.  Could
you use something like -9 for missing.  Some of us old dino types do it
(did it) that way. ;-)

Women and cats do as they please; men and dogs
should relax and get used to the idea.

<^..^>


catciao