Problems with PROC Transpose

[JeffG]

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

[flysnow]

the codes worked, as per my testing.