transpose data using arrays

[ravindra2]

hi masters,

i am having one dataset it has some data i want to transpose it by using only arrays.

data sbp;
input subject $ visit sbp;
datalines;
101 1 160
101 3 140
101 4 130
101 5 120
202 1 141
202 3 161
202 4 171
202 5 181
;
run;

[Kurt_Bremser]

Maxim 14: use the right tool. No arrays are needed, SAS has a procedure for this (Maxim 7):

proc transpose data=sbp out=want (drop=_name_) prefix=sbp;
by subject;
id visit;
var sbp;
run;

[novinosrin]

why not proc transpose as @Kurt_Bremser neatly puts. Any particular reason like learning?

[Ksharp]

Is there any reason that you have to use data step ?

data sbp;
input subject $ visit sbp;
datalines;
101 1 160
101 3 140
101 4 130
101 5 120
202 1 141
202 3 161
202 4 171
202 5 181
;
run;
proc sql noprint;
select max(visit) into : n separated by ' ' from sbp;
quit;
data want;
 set sbp;
 array x{*} visit1-visit&n;
 retain visit:;
 by subject;
 x{visit}=sbp;
 if last.subject;
 drop visit sbp;
run;

[ballardw]

---

@ravindra2 wrote:

hi masters,

i am having one dataset it has some data i want to transpose it by using only arrays.

data sbp;
input subject $ visit sbp;
datalines;
101 1 160
101 3 140
101 4 130
101 5 120
202 1 141
202 3 161
202 4 171
202 5 181
;
run;

---

1) why force data step and

2) What specific result should your transpose look like?