Help using Base SAS procedures

Problems with PROC Transpose

Reply
N/A
Posts: 1

Problems with PROC Transpose

I have data that looks like this:

location,label,value
1,A,0
1,B,1
2,A,1
2,B,0

However, I would like to transpose it to make it look like this:

location,A,B
1,0,1
2,1,0

I have tried the following code, which gives me an error:

PROC TRANSPOSE data=before out=after let;
by location;
id label;
RUN;

Any help would be much appreciated. Thanks!

-

Nevermind, this code works fine.

Message was edited by: JeffG Message was edited by: JeffG
Occasional Contributor
Posts: 5

Re: Problems with PROC Transpose

the codes worked, as per my testing.
Ask a Question
Discussion stats
  • 1 reply
  • 227 views
  • 0 likes
  • 2 in conversation