topic Re: transpose data using arrays in SAS Programming

transpose data using arrays

ravindra2 — Thu, 08 Nov 2018 11:43:24 GMT

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;

Re: transpose data using arrays

Kurt_Bremser — Thu, 08 Nov 2018 11:54:02 GMT

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;

Re: transpose data using arrays

novinosrin — Thu, 08 Nov 2018 12:38:31 GMT

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

Re: transpose data using arrays

Ksharp — Thu, 08 Nov 2018 12:40:24 GMT

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;

Re: transpose data using arrays

ballardw — Thu, 08 Nov 2018 15:28:08 GMT

@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?