topic Re: transpose data set in SAS Programming

transpose data set

pritikhaire84 — Fri, 03 Nov 2017 05:18:27 GMT

 
Hi all,
 
How to transpose this data set which has only one column 
i.e. attribution and its data is like A. M&M Process ...etc.

attribution_transposed:
attribution
C. M&M Process
B. Supplier Design
 
thanks in advance..

Re: transpose data set

PeterClemmensen — Fri, 03 Nov 2017 06:43:51 GMT

So you want to transpose a data set with only 1 column, so that it has only 1 observation?

What do you want the variable names to be?

Re: transpose data set

pritikhaire84 — Fri, 03 Nov 2017 07:21:35 GMT

there is only one column (attribution) in that data set (attribution_transposed)
and want to transpose it

Re: transpose data set

Astounding — Fri, 03 Nov 2017 10:59:04 GMT

You will need to learn about PROC TRANSPOSE. Here's a basic example to get you started:

proc transpose data=have prefix=attribution out=attribution_transposed (drop=_name_);

var attribution;

run;