DATA Step, Macro, Functions and more

SYSTIME

Accepted Solution Solved
Reply
Occasional Learner
Posts: 1
Accepted Solution

SYSTIME

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.


Accepted Solutions
Solution
‎04-12-2017 08:11 AM
PROC Star
Posts: 7,474

Re: SYSTIME

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

View solution in original post


All Replies
Solution
‎04-12-2017 08:11 AM
PROC Star
Posts: 7,474

Re: SYSTIME

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 128 views
  • 1 like
  • 2 in conversation