DATA Step, Macro, Functions and more

Proc Transpose

Accepted Solution Solved
Reply
Contributor
Posts: 50
Accepted Solution

Proc Transpose

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= _Smiley Happy label=DESC PREFIX = Gender;
by  Year;
/*id Boys Girls;*/
VAR Boys Girls;
run;

 

 

Please help.

 

KR

SK


Accepted Solutions
Solution
‎09-24-2016 09:34 AM
Super User
Super User
Posts: 6,500

Re: Proc Transpose

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

View solution in original post


All Replies
Solution
‎09-24-2016 09:34 AM
Super User
Super User
Posts: 6,500

Re: Proc Transpose

proc transpose data = years  label=DESC name = Gender
  out=years1 (rename=(col1=Count)) 
; 
  by  Year;
  var Boys Girls;
run;
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 246 views
  • 1 like
  • 2 in conversation