Hi, I want to create a new dataset (or a column in the existing dataset) that adds the lagged values if a condition is met. Say, the condition is when:  lagDays<7 then add the corresponding value for the variable "chrg" with its preceding value.  Here is an example for your consideration:   data have; input id $3. chrg lagDays; datalines; 001 19 . 001 30 23 001 23 45 001 35 1 001 29 2 002 66 . 002 59 34 002 70 19 003 55 . 003 90 10 003 91 4 003 19 6 003 33 1 003 45 22 003 87 1 003 90 1 003 43 45 ; run; data want; input id $3. chrg lagDays adjchrg $20.; datalines; 001 19 . 19 001 30 23 30 001 23 45 23 001 35 1 23+35 001 29 2 23+35+29 002 66 . 66 002 59 34 59 002 70 19 19 003 55 . 55 003 90 10 90 003 91 4 90+91 003 19 6 90+91+19 003 33 1 90+91+19+33 003 45 22 45 003 87 1 45+87 003 90 1 45+87+90 003 43 45 45 ; run; proc print data=have; run; proc print data=want; run; Thanks in advance. ... View more

How to drop cases that does not contain any of the given strings of characters delivered through a local macro?   data test; input id $ b c $ d e $ f; datalines; AAA 50 11 1 222 22 BBB 35 12 2 250 25 CCC 75 13 3 990 99 ; run; proc contents data=test out=vars(keep=name type) noprint; run; %let rvar = "id", "b"; %let rvar1 = "c", "d", "e", "f"; data vars; set vars; if name NOT in (&rvar); *Of course this line will not work; *if name in (&rvar1); /*IT works if I set 'rvar' accordingly. Though, this can be an option, thre are so many variables to consider for my data set under this condition; */ run;   Exisiting data; Desired data: ... View more