topic re-organizing a data set - freq transpose? in SAS Programming

re-organizing a data set - freq transpose?

Yoko — Tue, 11 Sep 2018 12:46:08 GMT

Hello,

I have a data like this:

DATA mydata1;
input id code1 code2 code3;
DATALINES;
1 5 9 13
2 6 10 14
3 7 11 15
4 8 12 16

;
run;

Then, I want to re-organize the data such that a new data set looks like this:

id code

1 5

1 9

1 13

2 6

2 10

2 14

3 7

3 11

3 15

4 8

4 12

4 16

Is it possible to do this? If so, how can I re-organize my data?

Thank you!

Yoko

Re: re-organizing a data set - freq transpose?

PeterClemmensen — Tue, 11 Sep 2018 12:51:10 GMT

DATA mydata1;
input id code1 code2 code3;
DATALINES;
1 5 9 13
2 6 10 14
3 7 11 15
4 8 12 16

;
run;

proc transpose data=mydata1 out=want(rename=(COL1=code) drop=_NAME_);
    by id;
    var code1-code3;
run;

Re: re-organizing a data set - freq transpose?

Yoko — Tue, 11 Sep 2018 12:57:01 GMT

It worked, thank you!

Re: re-organizing a data set - freq transpose?

PeterClemmensen — Tue, 11 Sep 2018 17:21:36 GMT

No problem. Glad to help 🙂