Transposing a single variable.

deleted_user — Tue, 24 Nov 2009 07:06:59 GMT

My data set Names have only one variable, Person, like this:

Person
********
Adam
Eve
Ask
Embla

With the code:

proc transpose data=names out=names prefix=Name;
var person;
run;

I get:

_NAME_ _LABEL_ Name1 Name2 Name 3 Name4
person personlabel Adam Eve Ask Embla

In a data statement I can drop _NAME_ and _LABEL_, so I get what I want:

Name1 Name2 Name3 Name4
Adam Eve Ask Embla

Could that have been done directly in proc transpose?

Re: Transposing a single variable.

DanielSantos — Tue, 24 Nov 2009 07:58:13 GMT

Yes.

You should specify the drop statement at the output table, like this:

[pre]proc transpose data=names out=names (drop = _:) prefix=Name;
var person;
run;[/pre]

drop = _: is actually a wildcard (_*) , it works like drop any variable that stars with _

Cheers from portugal.

Daniel Santos @ www.cgd.pt

topic Transposing a single variable. in SAS Procedures

Transposing a single variable.

Re: Transposing a single variable.