Help using Base SAS procedures

Row entries to column headers?

Accepted Solution Solved
Reply
Learner
Posts: 1
Accepted Solution

Row entries to column headers?

Hello,

 

I've got 3 columns of data

1 A 1.1

1 B 1.3

1 C 1.4

2 A 1.2

2 B 3.4

2 C 2.9

3 A 0.9

3 B 1.0

3 C 4.2

 

I'd like to modify it so I have something that looks like

-A B C

1

2

3

 

And having the values match up. Any ideas? I thought maybe a transpose, but couldn't get it to work.

 

(Sorry for the terrible formatting)


Accepted Solutions
Solution
‎11-11-2015 06:33 PM
Super User
Super User
Posts: 7,054

Re: Row entries to column headers?

Posted in reply to CraftyMontezz

Proc Transpose will do that, I think.

data have ;
  input id name $ value ;
cards;
1 A 1.1
1 B 1.3
1 C 1.4
2 A 1.2
2 B 3.4
2 C 2.9
3 A 0.9
3 B 1.0
3 C 4.2
;
proc transpose data=have out=want (drop=_name_) ;
  by id;
  id name ;
  var value;
run;

The will produce this data

ID A  B   C
1 1.1 1.3 1.4
2 1.2 3.4 2.9
3 0.9 1    4.2

View solution in original post


All Replies
Solution
‎11-11-2015 06:33 PM
Super User
Super User
Posts: 7,054

Re: Row entries to column headers?

Posted in reply to CraftyMontezz

Proc Transpose will do that, I think.

data have ;
  input id name $ value ;
cards;
1 A 1.1
1 B 1.3
1 C 1.4
2 A 1.2
2 B 3.4
2 C 2.9
3 A 0.9
3 B 1.0
3 C 4.2
;
proc transpose data=have out=want (drop=_name_) ;
  by id;
  id name ;
  var value;
run;

The will produce this data

ID A  B   C
1 1.1 1.3 1.4
2 1.2 3.4 2.9
3 0.9 1    4.2
🔒 This topic is solved and locked.

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

Discussion stats
  • 1 reply
  • 240 views
  • 2 likes
  • 2 in conversation