topic creating vertical data structure in SAS Programming

creating vertical data structure

SAS_inquisitive — Tue, 28 Feb 2017 13:21:46 GMT

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 — Tue, 28 Feb 2017 13:27:10 GMT

Proc Transpose

Arrays method

RW9 — Tue, 28 Feb 2017 13:27:35 GMT

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 — Tue, 28 Feb 2017 13:28:39 GMT

Use proc transpose.