topic Re: How to change observations to variables in SAS Data Management

How to change observations to variables

r4321 — Sun, 11 Feb 2018 23:28:02 GMT

Hello all,

I'm hoping you can help me with some code to change observations to variables, I have data with a structure like so:

ID Date UniqueVal

1 D1 111

1 D2 222

1 D3 333

2 D1 111

2 D2 222

2 D3 333

3 D1 111

3 D2 222

3 D3 333

I want:

ID D1 D2 D3

1 111 222 333

2 111 222 333

3 111 222 333

Hopefully that makes sense. Anyway, thank you in advance for your guidance.

Re: How to change observations to variables

novinosrin — Sun, 11 Feb 2018 23:30:04 GMT

did you try proc transpose?

Re: How to change observations to variables

r4321 — Sun, 11 Feb 2018 23:32:25 GMT

I have messed with it yes, but I couldn't produce the results I needed. Could you provide example code? Thank you!

Re: How to change observations to variables

novinosrin — Sun, 11 Feb 2018 23:32:57 GMT

data have;
input ID     Date $   UniqueVal;
datalines;
1        D1         111
1        D2         222
1        D3         333
2        D1         111
2        D2         222
2        D3         333
3        D1         111
3        D2         222
3        D3         333
;

proc transpose data=have out=want(drop=_name_);
by id;
var UniqueVal;
id date;
run;

Re: How to change observations to variables

r4321 — Sun, 11 Feb 2018 23:45:00 GMT

Excellent, thank you!