topic Re: Date Macro Help in SAS Programming

Date Macro Help

AAWTomHanks — Fri, 13 May 2016 14:12:17 GMT

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.

Re: Date Macro Help

LinusH — Fri, 13 May 2016 14:24:42 GMT

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

Re: Date Macro Help

RW9 — Fri, 13 May 2016 14:27:36 GMT

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.

Re: Date Macro Help

FreelanceReinh — Fri, 13 May 2016 14:30:05 GMT

Hi @AAWTomHanks,

Try this:

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