topic Re: SAS lag and lead problem in SAS Programming

SAS lag and lead problem

harrylui — Thu, 27 Feb 2020 08:02:48 GMT

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

Re: SAS lag and lead problem

PeterClemmensen — Thu, 27 Feb 2020 08:10:13 GMT

Try this

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

Re: SAS lag and lead problem

harrylui — Thu, 27 Feb 2020 08:25:18 GMT

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

Re: SAS lag and lead problem

ed_sas_member — Thu, 27 Feb 2020 08:28:08 GMT

HI @harrylui

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

Options mergeNoBy=noWarn ;

Re: SAS lag and lead problem

PeterClemmensen — Thu, 27 Feb 2020 08:29:47 GMT

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

Re: SAS lag and lead problem

harrylui — Thu, 27 Feb 2020 13:57:48 GMT

thank you!

Re: SAS lag and lead problem

harrylui — Thu, 27 Feb 2020 13:58:13 GMT

thank you! my problem is fixed!

Re: SAS lag and lead problem

Krueger — Thu, 27 Feb 2020 14:13:52 GMT

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