SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Siddharth123
Obsidian | Level 7

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

1 ACCEPTED SOLUTION

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

View solution in original post

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

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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