topic Re: How to fill up the range in SAS Procedures

How to fill up the range

MajaFerencakovic — Sat, 19 Jan 2013 12:43:37 GMT

Hello,

last few hours I was fighting with something I was thinking will be easy, but I now I need you help.

I have data set that looks like this;

id start end

1 5 12

1 18 56

1 69 89

1 95 110

2 2 7

2 9 13

2 50 90

3 4 8

3 10 13

3 93 120

3 125 135

Start and end variables are actually beginning and end of a range. Maximum end value is 150 for all ids.

What I would like to have is id and var 1 to 150 with rages filled with 1, and things outside range filled with 0. Beginning and end of range should also be coded as 1.

so for example

id var1 var2 var3 var4 var5 var6 var7 var8 var9 var10 var11 var12 var13 var14....var150

1 0 0 0 0 1 1 1 1 1 1 1 1 0 0 0.......

2 0 1 1 1 1 1 1 0 1 1 1 1 1 0 0.....

3 0 0 0 1 1 1 1 1 0 0 1 1 1 0 0...

Thank you

Re: How to fill up the range

Linlin — Sat, 19 Jan 2013 14:14:36 GMT

Hi,

try the code below:

data have;

input id start end;

cards;

1 5 8

1 10 12

2 2 7

2 9 13

;

data temp;

set have;

array _var(*) var1-var150;

do i=1 to 150;

_var(i)=ifn(i ge start and i le end,1,0);

end;

proc summary data=temp nway missing ;

class id;

var var1-var150; ;

output out=want (drop=_:) max= ;

run;

proc print;run;

Re: How to fill up the range

MajaFerencakovic — Sat, 19 Jan 2013 14:25:37 GMT

looks great!

Thanks a lot?

What do think could I go for 150 000 000 variables?