topic Re: Selective Transposition in SAS Programming

Selective Transposition

ilikesas — Sat, 15 Jul 2017 20:51:13 GMT

Hi,

I have a data table in the following form:

Company	Var	year_2001	year_2002
A	x	11	31
A	y	12	32
A	z	13	33
B	x	21	41
B	y	22	42

And I would like this table to be transformed into the following table:

Company	year	x	y	z
A	year_2001	11	12	13
A	year_2002	31	32	33
B	year_2001	21	22	.
B	year_2002	41	42	.

So here what I need is to transform the values of "Var" into columns, and to transform the "2001" and "2002" columns into a new column "Year".

Thanks!

Re: Selective Transposition

PeterClemmensen — Sat, 15 Jul 2017 20:40:23 GMT

2001 and 2002 are not valid SAS variable names 🙂

Re: Selective Transposition

SuzanneDorinski — Sat, 15 Jul 2017 21:58:06 GMT

data want;
  input company $ var $ year_2001 year_2002;
  datalines;
A x 11 31
A y 12 32
A z 13 33
B x 21 41
B y 22 42
;
run;

proc print data=want;
run;

proc transpose data=want 
               out=have
               name=year;
  by company;
  id var;
run;

proc print data=have;
run;

EDIT - realized after posting that I probably should have reversed the data set names. 🙂