topic Transpose data with dynamic variable lists in SAS Enterprise Guide

Transpose data with dynamic variable lists

JUN_Sands — Tue, 26 May 2015 21:46:24 GMT

Hi All,

I have multiple datasets with various number of variables in each dataset and I am trying to transpose them with using one code of loop.

For example, this is what I have got.

............

And I am trying to use VAR _ALL_; but it made source and location columns as variables.

Proc Transpose data=work.comparison_want_&sas_name

out=work.comparison_want_t_&sas_name

name=Location

Label=Search_Engine
Prefix=Ranking;

by Source Location;

var _ALL_;

Run;

New Table from the first table would be like this..

Source	Location	Numbers_List
a	aaa	2
a	aaa	5
a	aaa	6
b	bbb	4
b	bbb	5
b	bbb	6
c	ccc	2
c	ccc	5
c	ccc	6

Please pardon my poor explanation... Anyone has an idea ?

Thanks!!

Steelers_In_DC — Wed, 27 May 2015 11:10:48 GMT

It would be helpful to give an example dataset for what you have and the result you are looking for.

TomKari — Wed, 27 May 2015 11:59:04 GMT

If your other columns are numeric, just leave out the VAR statement; the procedure will use all of the variables not named in BY.

JUN_Sands — Wed, 27 May 2015 15:29:43 GMT

Please see revised question. Desired output has been added. Thanks.