Date:         Fri, 14 Oct 2005 15:00:01 -0400
Reply-To:     "Fehd, Ronald J" <rjf2@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Fehd, Ronald J" <rjf2@CDC.GOV>
Subject:      Re: Proc transpose questions
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.

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

where ID ne .

> Two, I don't want the _NAME_ and _LABEL_ columns.
> I can drop them, but
> I was hoping to avoid a datastep after the proc transpose
> and hoped I missed an option to not output them.

you'll have an output statement
add data step options to that:

out = DataName(drop = _NAME_ _LABEL_ )

Ron Fehd  the macro maven  CDC Atlanta GA USA RJF2 at cdc dot gov