topic Re: transposing datsets in New SAS User

transposing datsets

jainamistryx — Mon, 15 Oct 2018 08:15:03 GMT

Hi!

I am a new user to SAS and was wondering how I go about transposing my dataset. It currently looks like the following:

continent industry total

A 0509 37

B 0509 78

C 0509 12

A 1315 85

B 1315 26

C 1315 73

and I need it to look something like this:

continent

industry variable A B C

0509 total 37 78 12

1315 total 85 26 73

Should I use proc transpose? Apologies if this is very simple, I am very new to SAS !! 🙂

Thank you!

Re: transposing datsets

Amir — Mon, 15 Oct 2018 09:23:29 GMT

Hi,

How about:

proc transpose data = have
               out  = want;
   by industry;
run;

Regards,

Amir.

Re: transposing datsets

Kurt_Bremser — Mon, 15 Oct 2018 10:52:23 GMT

To get the variable names you want, the transpose as suggested by @Amir needs some additions:

proc transpose
  data=have
  out=want (rename=(_name_=variable))
;
by industry;
id continent;
run;

Re: transposing datsets

jainamistryx — Mon, 15 Oct 2018 10:58:51 GMT

That works perfectly - thank you so much!

Re: transposing datsets

data_null__ — Mon, 15 Oct 2018 17:44:30 GMT

@Kurt_Bremser wrote:

To get the variable names you want, the transpose as suggested by @Amir needs some additions:
proc transpose
  data=have
  out=want (rename=(_name_=variable))
;
by industry;
id continent;
run;

PROC TRANSPOSE has a PROC statement option NAME= to give a name to the "variable name" variable. Kind of a 6 of 1 half dozen thing regarding which to use.