Did you try PROC APPEND ? proc append base=spe.limits data=limits5 force; run; ... View more

thank you for clarity and noted ... View more

@Tom     Yes this works, thank you appreciate it ... View more

set GEN.TRANSACT_BASE_201909 - GEN.TRANSACT_BASE_202308;   SAS thinks that this list of data set names goes from integer 201909 to integer 202308, and so what integer comes after 201912? Why 201913, of course, and this data set does not exist. SAS does not know that this is a list of months where 201913 is impossible.   You probably could create a list of data set names in library GEN that actually exist, via a macro variable. In this case, we query the dictionary tables to find out what data sets actually exist in GEN, and store the results in a macro variable &DSNAMES   /* UNTESTED CODE */ proc sql noprint; select distinct cats('gen.',memname) into :dsnames separated by ' ' from dictionary.tables where libname='GEN' and input(substr(memname,15),6.) between 201909 and 202308; quit;   and then use   set &dsnames;   ... View more

Thanks a lot @Kurt_Bremser , it works i just changed  and a.acct_status = "reactivated" to  where a.acct_status = "reactivated"   ... View more

data transactions; input yearmonth :yymmn6. acct_no $ status $; format yearmonth yymmn6.; datalines; 202301 1 inactive 202301 2 active 202302 1 inactive 202302 2 active 202302 3 inactive 202303 3 active 202302 4 active ; data want; if _n_=1 then do; if 0 then set transactions(rename=(status=_status)); declare hash h(dataset:'transactions(rename=(status=_status))'); h.definekey('yearmonth','acct_no'); h.definedata('_status'); h.definedone(); end; set transactions; length StatusNew $ 40; StatusNew=status; prev_yearmonth=intnx('month',yearmonth,-1); if h.find(key:prev_yearmonth,key:acct_no)=0 then do; if status='active' and _status='active' then StatusNew='active '; if status='active' and _status='inactive' then StatusNew='re-active'; end; drop _status prev_yearmonth; run; ... View more

Hi @PaigeMiller , your proposed solution gives me desired results. Thanks a lot, always learning from you! ... View more

If CH_ACCT_NO is stored as a number, this needs to be rectified first, at the point where the data is read into the SAS environment. Account "numbers" are not numbers used for calculations, they are just codes, which m7st be stored as character. In the moment they exceed 15 decimal digits, the limits of numerical precision will kick in and lead to unpredictable and wrong results. ... View more

@ChrisHemedinger    I was thinking the same about ChatGPT learning from wrong or sub-optimal answers. In addition, there are a lot of SAS users who think that if they want to change a format, a new variable is needed! I see this all the time in the people I work with, and with data sets of potentially millions of records and possibly hundreds of variables, creating one new variable is a lot of work for the computer and a lot more disk space, not to mention the problems caused by converting a numeric date value into a character string (as ChatGPT is recommending and which I objected to). ... View more

For SAS EG there are "prompts", SAS even did a video about it: https://video.sas.com/detail/video/6295499870001/create-and-use-prompts-in-queries-and-tasks   Bart ... View more

Most likely you will have to add code to your process writing the excel-files. Posting more details about your process and what you want to export will help to get more detailed answers. Also note, that if the process runs on a sas server, it is hardly possible to write files to a local drive on a computer. ... View more