FYI - This code returns the wrong value for cmonth_name. Don't use the month() function when using monname. The format needs to be used with a date.   I modified here for the correct solution for the request. Notice the difference in line 3: data _null_; call symputx('cmonth',month(today())); call symputx('cmonth_name',put(today(),monname.)); call symputx('pmonth',month(intnx('month',today(),-1))); call symputx('cyear',year(today())); call symputx('pyear',year(intnx('month',today(),-1))); run; ... View more

In a data step:   Data want;     set have;     where priority=1; run;   will keep only records with the stated priority value. If the value is character then it would have the value inside quote marks.     ... View more

With that long of a period I would examine any file dependency issues. DDE is only one. I may be of importance to know that the communication methods DDE was designed to use are interfered with by other programs these days. My specific example is Cisco Jabber. I had a process that used DDE because I couldn't get management to spring for the SAS/Access Interface to PC Files. Which quit working when Jabber was installed. And in this specific case halting the active window of Jabber was not sufficient but using Task Manager to kill the process allowed DDE to work. Another specific to DDE is you have a moving target in the file format definitions. Code that worked with Office 2007 (or what ever) quits with later versions of Office as each release is likely to require a different file type parameter. I am lucky in that I do not have to "place" values into an Excel "template" (which has many different meanings to different users) but I might examine use of either ODS Excel or ODS Tagsets.Excelxp to see if equivalent documents can be created from scratch getting completely away from the basically no longer supported and definitely not improved DDE from Microsoft. Or possible discuss with management if the entire process needs revision (neat new features as an opportunity to get away from "template").   Output is another thing to look at closely. Graphic procedures likely should be moved to SG graphics or examined for the many newer options if SG graphics were used. ODS options have increased in either general definitions or style overrides inside report procedures and possibly Proc Document may be helpful for assembling complex reports. Newish procedures like Proc ODSTEXT and Proc ODSLIST may provide alternatives to either ODS Text output or File Print.   You might also want to mine the "What's New" sections of the releases of SAS 9.2 and later to see if there are bits that look helpful for your   ... View more