Looking ahead in SAS

Question

I need to create a lead variable in my data set in SAS.

I used the simple method:

proc expand data=data out=data_lead method = none; 
convert rate; 
convert rate = rate_lead5  / transformout=(lead 5); 
run;

But SAS required more resources (My data is about 220 GB)

Is there any simple way to create a 5-step-ahead variable without utilizing so much memory ? Thanks !

Have a look at @Joe answer here: http://stackoverflow.com/a/30332066/3972769 — Bendy, May 28 '15 at 10:50
So there's no BY variable or anything else - just 220GB of data rows, all a single time sequence, and you're wanting 5 rows ahead pasted on? — Joe, May 28 '15 at 14:10

score 1 · Answer 1 · edited May 23 '17 at 12:06

1

As mentioned in my comment, take a look at Joe's answer to this question. However, if you only need to read each record 5 steps ahead (rather than 5 variables 1-5 steps ahead) then you can use his technique but without a macro by just doing:

data data_lead ;
  merge data data(firstobs=5 rename=(rate=rate_lead5)) ;
run ;

edited May 23 '17 at 12:06

Community

1
1

answered May 28 '15 at 12:41

Bendy

3,506
6
40
71

Looking ahead in SAS

1 Answers1