topic Re: Need help with Proc Transpose in SAS Programming

Need help with Proc Transpose

Phoenix232 — Tue, 07 Feb 2017 09:14:13 GMT

Hi All,

I have a large dataset out of which i need to summarize and present a few numbers from it.

My current dataset looks something like below :

Var1 Var2 Var3 Var4 Var5 Var6 Var7

num1 num2 num3 num4 num5 num6 num7

there is nothing i could think of which would make the above dataset look like :

heading heading

Var1 num1

var2 num2

Var3 num3

........... and so on.

Any help would be appreciated.

Re: Need help with Proc Transpose

RW9 — Tue, 07 Feb 2017 09:20:54 GMT

If you post test data in the form of a datastep you are more likely to get working code. Something like:

data have;
  set have;
  id=_n_;
run;

proc transpose data=have out=want;
  by id;
  var var:;
run;

Re: Need help with Proc Transpose

Phoenix232 — Tue, 07 Feb 2017 09:32:11 GMT

What does Var: means ?

sorry, been programming after ages that i have forgotten even basic things.

Re: Need help with Proc Transpose

RW9 — Tue, 07 Feb 2017 09:36:35 GMT

Its a shorthand method of stating any variable with teh prefix given, so if I said:

abcd:

This would include any variable name with abcd as first four characters e.g. abcd1234, abcde, but not efg_abcd.

You could also use -- to specify a range (per sort order) of variable names and such like.

http://support.sas.com/documentation/cdl/en/lrcon/69852/HTML/default/viewer.htm#p0wphcpsfgx6o7n1sjtqzizp1n39.htm

Re: Need help with Proc Transpose

Phoenix232 — Tue, 07 Feb 2017 09:42:19 GMT

Thanks a ton, Your solution worked perfectly but i tweaked a bit.

I had mixed variable names and var: only targeted the specific ones.. i removed this line and dropped the id from the dataset to give out the desired results..

🙂 🙂