creating vertical data structure

[SAS_inquisitive]

Hello,

I have a data structure like this.

id time test_1 test_2

1   1     4       8

1   2     5       6

1   3     4       7

2   1     5       8

2   2     4       5

I want like this.

id time test     value

1  1    test_1    4

1  1    test_2    8

1  2    test_1    5

1  2    test_2    6

1  3    test_1    4

1  3    test_2    7

2  1    test_1    5

2  1    test_2    8

2  2    test_1    4

2  2    test_2    5

thanks for your help.

[Reeza]

Proc Transpose

http://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-wide-to-long-using-proc-transpose/

Arrays method

http://stats.idre.ucla.edu/sas/modules/reshaping-data-wide-to-long-using-a-data-step/

[RW9 · Accepted solution]

Post test data in the form of a datastep.  As such this is just an example:

proc transpose data=have out=want;
  by id time;
  var test_:;
run;

[Kurt_Bremser]

Use proc transpose.