topic transform sequence into varaibles in SAS Programming

transform sequence into varaibles

hello28 — Tue, 16 Oct 2018 17:40:16 GMT

Hi,

i have a sequence of observations as follows

I need to convert the continuous sequence into variables as below

var1 var2 var3 var4

0 4 24 26

i.e whenever there is a break in sequence, i need to capture min and max of previous sequence and store it in variable.

Re: transform sequence into varaibles

novinosrin — Tue, 16 Oct 2018 18:05:17 GMT

do you want a production code or fun solution. if former,

how many records do you estimate to have?

what would be array size aka horizontal

data have;
input n;
cards;
0
1
2
3
4
24
25
26
;
/*fun solution*/
data t;
set have;
if dif(n) ne 1 then k+1;
run;
data t1;
set t;
by k;
if first.k or last.k;
run;
proc transpose data=t1 out=want;
var n;
run;