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?
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