Proc Transpose

Siddharth123 — Sat, 24 Sep 2016 12:54:39 GMT

Hi All,

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

Raw Data -

Desired Output -

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.

Re: Proc Transpose

Tom — Sat, 24 Sep 2016 13:10:00 GMT

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