2 points:   Your desired result indicate that the logic should not be 'if previous bucket ..' . It should be 'if any of the previous bucket values within the same id group equals 4. I take it that the logic should hold for different by-groups.    Try the code below.   data have; input id bucket; datalines; 1 0 1 4 1 0 1 0 1 1 1 2 1 3 1 4 2 0 2 4 2 0 2 0 2 1 2 2 2 3 2 4 ; data want(drop = prev_4); set have; by id; if first.id then prev_4 = 0; if bucket = 4 then prev_4 = 1; length status $20; status = ifc(bucket = 4, 'bad', 'good'); if prev_4 = 1 & bucket < 4 then status = 'recover'; retain prev_4; run;   Result:   id bucket status 1 0 good 1 4 bad 1 0 recover 1 0 recover 1 1 recover 1 2 recover 1 3 recover 1 4 bad 2 0 good 2 4 bad 2 0 recover 2 0 recover 2 1 recover 2 2 recover 2 3 recover 2 4 bad   ... View more

@AndersS , I see you found your answer.    However, I will chime in and refer you to the article QuickSorting An Array by Paul Dorfman (aka the @hashman).   The %Qsort macro takes an array and sorts it using the Quicksort algorithm. Also, the macro takes the optional parameters lb and hb, so you can easily sort elements 3 to 10.   I recommend reading the entire article. Pure gold 🙂   Br ... View more

@DanielRingqvist , very nice! ... View more

Try this   data have; input id var; datalines; 1 5 1 6 2 2 2 3 2 9 ; proc sql; create table want as select id, var, sum(var) as sum from have group by id ; run; ... View more

Is your desired output a SAS data set or a .txt file? ... View more

Questions like this is much easier to answer if you provide a minimum of sample data and your desired result. ... View more

The log explains what the problem is. You run out of memory, which gives an error and stops the data step.    I suspect that the real question here is how to accomplish whatever you try to accomplish without the Data Step giving an error?   If that is the case, please provide a minimum of sample data and explain what the code above is suppose to do and the desired result.  ... View more

What is your desired result? ... View more

Try this   data test; date = '20231002'; new = put(input(date, yymmdd8.), date9.); run; ... View more

I think the log is pretty self explanatory. A few points though.   Using this syntax in the Set Statement assumes that a data set with the name transact_base  and the relevant suffix is available for each integer between 201909 and 202308. That being the integer, not the date. For example, you can see that SAS looks for the data set GEN.TRANSACT_BASE_201913, which is not available and gives an error.  There is really no need for a macro here. If you want to stack all the data sets prefixed with TRANSACT_BASE_ in the GEN library you can use the colon operator in the Set Statement like this set GEN.TRANSACT_BASE_: ;   A small working example, since I can't access your GEN library:   data TRANSACT_BASE_201911; x = 1; run; data TRANSACT_BASE_201912; x = 2; run; data TRANSACT_BASE_202001; x = 3; run; data want; set TRANSACT_BASE_: ; run;     ... View more

A simple typo 🙂 ... View more

The oldest date and the MAX date are two different things.    I think you want to do this   data have; input Specimendate_all :mmddyy10. Patient_ID $ Pending $; format Specimendate_all mmddyy10.; infile datalines dlm = ',' missover; datalines; 03/29/22,AB1,NO 03/29/22,AB1,NO 03/29/22,AB1,YES 03/29/22,AB1,NO 04/05/22,AB1,NO 04/05/22,AB1,YES 04/05/22,AB1,YES 04/05/22,AB1,NO ; proc sql; create table want as select *, max(Specimendate_all) as specimenpendingmax format = mmddyy10. from have ; quit; ... View more

Do you want a third row with the value of date3 also? ... View more

Why not create a format to mask the last 4 digits without actually changing the underlying value? ... View more