Special handling needs to be applied to dates that represent future events. Taking medications would be one.  We don't want to predict that a client receives meds until 99999 as prescribed when forecasting company profits, because that is just not realistic.  While a person on SSI may receive their benefits until their death and they may take a prescribed medication until that date, a business might try to practice their profits from those meds by setting a cut-off date value for the persons life expectancy or date-of- predicted death.   We don't pay our bills 6 years in advance.       ... View more

Are you sure that you want this record marked as Y A005 3 19SEP2016 30SEP2016 Y ... View more

what have you tried? How to create a data-step version of your data https://communities.sas.com/t5/help/faqpage/faq-category-id/posting#posting https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 How to Add attachments https://communities.sas.com/t5/Community-Memo/Adding-attachments-to-your-communities-posts/ba-p/464767 ... View more

libname fart "&mypath."; proc sql noprint ; select 'FART.'|| memname into :mylist separated by ' ' from dictionary.tables where libname='FART' and nobs>0 ; quit; data want; set &mylist. ; run; ... View more

why not just do something like this   proc sql noprint ; select 'drop table '||memname into :empties separated by ';' from dictionary.tables where libname='WORK' and nobs=0 ; &empties; quit; %let empties=; ... View more