Date Macro Help

[AAWTomHanks]

Hi,

I am trying to create an automated time staamp. This is what I have so far:

%LET TIME = %SYSFUNC(TIME() );

But this isn't giving me what I need. I need 9 digits with no "." in it, for example HHMMSSSSS. Does anyone know how to do that?

Thanks.

[LinusH]

%sysfunc lets you specify a format as a second parameter.

[RW9]

Q1 as normal, why does it need to be a macro?  Macro language is a text generation tool, it has no data structures or means to process data.  Base SAS is there to hold data and process it.  For instance, datastep has a function time(), which can be put into any format, and if need you can strip out any characters you need.  Simple.

[FreelanceReinh · Accepted solution]

Hi @AAWTomHanks,

Try this:

%LET TIME = %SYSFUNC(TIME(), b8601tm9.3);