SAS lag and lead problem

[harrylui]

good day,

here is my program,

data have;
input name $40.;
infile datalines dlm=',';
datalines;
A
AAAOTAXIUNION
AACARPETSDELHI
AADESIGNFURNZTURNSAMUTPRAKAN
AADRIVERTRAININGLTAUCKLAND
AAFOOTWEARCENTRALWORBANGKOK
AAFOOTWEARGAYSORNBANGKOK
AAFOOTWEAROUTLETAYUTTAYUTTHAYA
AAHONGKONG
AAMCLENNANGKMPOKOLBIN
;
run;

data have2;
set have;
lag_name=lag(name);

run;

i also want to add a lead Row here for comparison. can anyone help? 

thanks in advance

[PeterClemmensen · Accepted solution]

Try this

data have2;
    merge have
          have(firstobs=2 rename=(name=lead_name) keep=name);
    lag_name=lag(name);
run;

[harrylui]

NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
31
32 GOPTIONS ACCESSIBLE;
33
34 data have2;
35 merge have
36 have(firstobs=2 rename=(name=lead_name) keep=name);
37 lag_name=lag(name);
38 run;

ERROR: No BY statement was specified for a MERGE statement.


not work

[ed_sas_member]

HI @harrylui 

Could you try the same code with the following option before:

Options mergeNoBy=noWarn ;

[harrylui]

thank you!

[PeterClemmensen]

Please check that the MERGENOBY System Option is set to NOWARN.

[harrylui]

thank you! my problem is fixed!

[Krueger]

I always just reverse sort order and do lag(), this is WAY easier!