Unless I'm missing something...since " I’m just not sure what to do from here." isn't very clear on what you're trying to do from here Although I love SAS and am a giant proponent and you can probably end up doing this somehow in SAS I'd say this is a situation where you shouldn't use it. I would look into IFTTT instead and/or Outlook itself. ... View more

This is some question more generic as just SAS. It is about running business applications infrastructure supporting different stages of DTAP (Develop Test User-Acceptance Production) and using a business-reference date. You can see those settings as some generic set to be set up at startup of the business-processing for all kind of processes. For production business-systems often the today() setting is used. While in testing environments you must have a fixed setting to be able to do regression testing. with fixed test-datasets during a verification. Within that kind of processed a loop of recurrent daily processes can exist with a at that moment becoming point of date. I believe this is what you are doing. Putting is in one program and do a %include of that in every other program belonging will solve the redundancy.  Setting program. "bu_001_refdate.sas" .   %let  UDIR= My user directory\; .   %let  Uxlib=&UDIR.SAS TABLES\201408\; .   %let Rundate = 06AUG; . .  options dlcreatedir; . LIBNAME X "&Uxlib.&RUNDATE"; All of your other programs starting with:   %include "&ugenset.bu_001_refdate.sas" ; This is a start as you see to eliminate all kind of physical namings from the coding. By that the code will be able to run on all type of machinetypes with little modifications There must be a last step/process being run that validates all processing has ended successfully and a next iteration / new date / can be started. That is a nice trigger for a sas-job for creating/writing out the sas-source: bu_001_refdate.sas The ugenset macrovariabel is something to set in a startup/autoexec as there must be a location where your code is to be found. The %include is similar of calling a sub-program as used in many other program languages for modular constructs. ... View more

1) make a view for each and everyone of tables. 2) add dataset's option   alter=   to avoid being overwrite problem . Xia Keshan ... View more

Thank you both for great advice. I am trying to format the dates as in Ha Kui's example just to see the difference. I’m sure I’ll have more questions soon!   ... View more