topic Re: lag addition in SAS Programming

lag addition

PBsas — Thu, 30 Nov 2017 17:46:45 GMT

Can you please help with following?

data a;
input var1 $;
datalines;
a
b
c
d
e
;
run;

what I need is:

Reeza — Thu, 30 Nov 2017 17:47:40 GMT

RETAIN + CATX.

PBsas — Thu, 30 Nov 2017 17:53:33 GMT

data b ;
    length cat $200 ;
set a ;
retain cat;
cat = catx('-',lag(var1),var1) ;
run ;

This is what I have but not getting results i want.

Reeza — Thu, 30 Nov 2017 17:54:45 GMT

cat = catx('-',lag(var1),var1) ;

That doesn't make sense, you want to add the new variable, not the previous variable1 and current variable.

cat = catx('-',cat,var1) ;

PBsas — Thu, 30 Nov 2017 17:58:04 GMT

Thank you @Reeza