12-23-2015 01:56 PM - edited 12-23-2015 02:41 PM
****UPDATE: Would you know how to replace the ":" delimiters in the created_at variable whose values are in the ddmmmyyyy:hh:mm:ss format with an underscore? ****************
I have a program which outputs multiple excel files and two emails where the file name has the date (date_pulled). I need to revise the file names to provide the timestamp as well.
Is there a common SAS format, variable which is used for producing timestamps I can use instead? Or would you suggest revising the date_pulled values so it takes out the ":" delimiters from the created_at variable instead of using datepart on the created_at variable?
The filenames ar:
<file path>\Liaison QC Report &date_pulled..xml
Thanks for the suggestions in advance!
%local rc fid fidc;
%let created_at=%sysfunc(finfo(&fid,Create Time));
%let date_pulled = %sysfunc(datepart("&created_at."dt),yymmddn8.);
Need further help from the community? Please ask a new question.