Hi All,
I am trying to export (by proc export) an archive with the name in this file has a SYSTIME.
For ex:
PROC EXPORT DATA= grupo
OUTFILE= "&rote\HORA_&SYSTIME"
DBMS=EXCEL REPLACE;
SHEET="Utilizar_esse";
RUN;
But the problem is Windows dont recognize the name file results, because generates a special caracter in the name (colum):
c:\temp\Hour_10:57.XLS
So, the sas log file indicates to me that the file was succedes generate but is not real when I see in the Windows Explorer.
Can someone help me please?
Thanks.
I'd just wrap the systime macro variable in a call to the translate function (see: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000215153.htm) changing the colon to an underscore.
Art, CEO, AnalystFinder.com
I'd just wrap the systime macro variable in a call to the translate function (see: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000215153.htm) changing the colon to an underscore.
Art, CEO, AnalystFinder.com
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.