Proc Transpose

[Siddharth123]

Hi All,

I am trying to reshape my dataset but stuck in one thing.

Raw Data -

Year	Boys	Girls
1879	.	.
1880	490	.
1881	481	20

Desired Output -

Year	Gender	Count
1879	Boys	.
1879	Girls	.
1880	Boys	490
1880	Girls	0
1881	Boys	481
1881	Girls	20

I am using code below which does not give desired output.

proc transpose data = years  out=years1(drop= _:) label=DESC PREFIX = Gender;
by  Year;
/*id Boys Girls;*/
VAR Boys Girls;
run;

Please help.

KR

SK

[Tom · Accepted solution]

proc transpose data = years  label=DESC name = Gender
  out=years1 (rename=(col1=Count)) 
; 
  by  Year;
  var Boys Girls;
run;