BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ali_hash
Calcite | Level 5

Hi there,

I need to transpose this data without proc transpose. Here's the data I have:

FALL_SEMESTER_RAWFALL_SEMESTER_ADJSPRING_SEMESTER_RAWSPRING_SEMESTER_ADJ
18992.29395.6
28385.68587.8
39698.99093.3
49395.69697.8
56668.96771.1

And I would like the data to look like this:

ID      SEMESTER      TYPE      SCORE

1     FALL                    ADJ          XX

1     FALL                    RAW         XX

1     SPRING               ADJ          XX

1      SPRING          RAW            XX

...

This is what I tried but not working out too well. Any help is appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User

Code: Program

data have;
infile cards truncover expandtabs;
input FALL_SEMESTER_RAW FALL_SEMESTER_ADJ SPRING_SEMESTER_RAW SPRING_SEMESTER_ADJ;
cards;
89 92.2 93 95.6
83 85.6 85 87.8
96 98.9 90 93.3
93 95.6 96 97.8
66 68.9 67 71.1
;
run;
data want;
set have;
array x{*} _numeric_;
ID=_n_;  
do i=1 to dim(x);
  SEMESTER=scan(vname(x{i}),1,'_');
  TYPE=scan(vname(x{i}),-1,'_');
  SCORE=x{i};
  output;
end;
keep ID   SEMESTER   TYPE   SCORE ;
run;

View solution in original post

2 REPLIES 2
Ksharp
Super User

Code: Program

data have;
infile cards truncover expandtabs;
input FALL_SEMESTER_RAW FALL_SEMESTER_ADJ SPRING_SEMESTER_RAW SPRING_SEMESTER_ADJ;
cards;
89 92.2 93 95.6
83 85.6 85 87.8
96 98.9 90 93.3
93 95.6 96 97.8
66 68.9 67 71.1
;
run;
data want;
set have;
array x{*} _numeric_;
ID=_n_;  
do i=1 to dim(x);
  SEMESTER=scan(vname(x{i}),1,'_');
  TYPE=scan(vname(x{i}),-1,'_');
  SCORE=x{i};
  output;
end;
keep ID   SEMESTER   TYPE   SCORE ;
run;
Rick_SAS
SAS Super FREQ

Why can't you use PROC TRANSPOSE?

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!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1330 views
  • 0 likes
  • 3 in conversation