It is extremely frustrating going from one date format to another.  It feels like each time I'm using a date function, it calls for something different.  What is the inner logic that governs all these different SAS date formats.  All I want to do is to take the difference in months between two dates.  Apparently, INTNX only accepts something like ' 05JAN2014'd.  So how do I convert 05JAN2014:00:00:00 into the required format? ... View more

Hello, is there a way to automatically generate a pre-formatted XLSX?  The reason is that I need to set a timer to generate a XLSX.  Proc export is not useful because it is stripping the formatting; setting up a libref (libname ... xlsx) also seems to be a data-dump only.  Now, ODS has formatting, but I need to manually download the XLSX.  Is there some way to automate the downloading?  Thanks!   ods Excel file="&SASFolder.&FirstReport" style=Journal options(sheet_name="Data" frozen_headers="1"); proc print data=FirstReport noobs; run; ods Excel close;   ... View more

Hi, I'd like to create a macro variable holding a file name that will be used in proc export.  The filename will contain a company and a date, like "ABC -- 20200605.xlsx".  First there what is a better way than adding in layers of %sysfunc? %let FileName=%sysfunc(cats(ABC, %sysfunc(putn(%sysfunc(today()), yymmddd.)))); %put &FileName;   Second, SAS returned ABC--9, which does not have a date. ... View more