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-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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