Transponse columns

PatrykSAS — Fri, 07 Jan 2022 11:45:47 GMT

I always find it very difficult to transpose tables. In my data, I have values for each month given in a separate column. I would like to make 2 columns out of this, one with the month name, the other with the value from the column. Just like in the example.

Before

data example;
   input country $ company $ type $ jan feb mar apr;
   datalines;
US Sico A 12 15 18 20
US Polo B 8 7 24 25
UK Sico B 6 5 5 4
UK Vax A 16 20 22 24
;

After

data example;
   input country $ company $ type $ month $ prod;
   datalines;
US Sico A jan 12
US Sico A feb 15
US Sico A mar 18
US Sico A apr 20
US Polo B jan 8
US Polo B feb 7
US Polo B mar 24
US Polo B apr 25
;
*and so on

Can you help me with this transposition?

Re: Transponse columns

novinosrin — Fri, 07 Jan 2022 12:15:19 GMT

data example;
   input country $ company $ type $ jan feb mar apr;
   datalines;
US Sico A 12 15 18 20
US Polo B 8 7 24 25
UK Sico B 6 5 5 4
UK Vax A 16 20 22 24
;

proc transpose data=example out=want(rename=( _name_=month col1=prod));
  by country company type notsorted;
  var jan--apr;
 run;

topic Re: Transponse columns in SAS Programming

Transponse columns

Re: Transponse columns