topic Re: Datestamp output in SAS Programming

Datestamp output

Planck — Tue, 10 Jan 2017 15:41:40 GMT

Hi,

I'm trying to save my SAS Table and first I want to rename it with the datestamp.

This is my code:

PROC FORMAT;
PICTURE datestamp(default=15)other='%Y%0m%0d%0H%0M%0S' (datatype=datetime);
RUN;

data FILENAME_%sysfunc(datetime(),datestamp);
set FILENAME;
RUN;

proc copy inlib=work outlib=output ;

select FILENAME_%sysfunc(datetime(),datestamp);

run;

But it's not working because before the datestamp I have a blank...Something like "FILENAME_ 20170110163415"

And I don't understand why. Do you know?

Thanks

Re: Datestamp output

Kurt_Bremser — Tue, 10 Jan 2017 15:48:00 GMT

Use this

data _null_;
call symput('datestamp',strip(put(datetime(),datestamp.)));
run;

and use &datestamp in place of your %sysfunc's.

Re: Datestamp output

LinusH — Tue, 10 Jan 2017 15:49:13 GMT

Try %left.

Re: Datestamp output

TheShark — Tue, 10 Jan 2017 15:49:51 GMT

I would set a macro variable for the datestamp and then call that.

PROC FORMAT;
PICTURE datestamp(default=15)other='%Y%0m%0d%0H%0M%0S' (datatype=datetime);
RUN;
 
%let datestamp=%sysfunc(datetime(), datestamp.);

data FILENAME_&datestamp.;
set FILENAME;
RUN;

Re: Datestamp output

Kurt_Bremser — Tue, 10 Jan 2017 15:53:21 GMT

Also keep in mind that datetime() always returns the CURRENT date&time, so the results of your %sysfunc's would be different if the program ran in more than one second!

Re: Datestamp output

Astounding — Tue, 10 Jan 2017 15:54:13 GMT

Could this be happening because your default length is 15 instead of 14? You are only filling 14 characters.

Re: Datestamp output

Planck — Tue, 10 Jan 2017 16:24:00 GMT

Perfect,

Thank you for all your reply, it works