Have a look at the code below. If you want to execute you need to place a path that works for you. %let path = your_folder_path; proc export data = sashelp.cars(keep = drivetrain make model origin type) outfile = "&path.class.txt" dbms = dlm replace; delimiter=';'; run; /*Syntax1*/ proc import datafile = "&path.class.txt" out = cars1 replace; GETNAMES = yes; DELIMITER = ';'; run; /*Syntax2*/ data cars2; length drivetrain $100 make $100 model $100 origin $100 type $100; infile "&path.class.txt" dsd dlm = ";"; input make model type origin drivetrain; run; ... View more

Help is not a very descriptive subject. Please on subsequent posts use a better subject so that readers get a good idea on what you want help with.   I think the issue is a failure in the code that implements your rule for the first obs in the by group. In your code on the first.acct_no you only set statusnew. I believe you also need to do something with the lag(status) because otherwise the lag(status) is the status of last.acc_no. Give the code below a try to verify if that solves your rule logic issue. data results; set transactions; by acct_no; length statusnew $12; retain statusnew ' '; lagstatus = lag(status); if first.acct_no then do; statusnew = status; lagstatus = " "; end; else do; if lagstatus = "active" and status = "active" then statusnew = "Active"; else if lagstatus = "inactive" and status = "active" then statusnew = "Re-activated"; else statusnew = status; end; if last.acct_no then output; drop lagstatus; run;   ... View more