> 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