topic Re: Using current date (TODAY() as macro variable entry for naming a dataset (scripting) in Discussions

Using current date (TODAY() as macro variable entry for naming a dataset (scripting)

Newbie2Jumpie — Fri, 28 Jun 2019 15:31:21 GMT

I would like to use TODAY() to derive the current date and use it as a timestamp in naming a JMP dataset, and as a TIME_STAMP column as well. In SAS, it may look like this (I admit I neglected the formatting a bit).

%let TODAYDATE=today();
data WORK.CLASS_&TODAYDATE. ;
set SASHELP.CLASS;
TIME_STAMP = &TODAYDATE.  ;
run ;

After resolving, the result should look like this :
"WORK.CLASS_20190628"
and
"TIME_STAMP
20190628
20190628
20190628
20190628
..."

May JSL macro variables do the same job?

Any input greatly appreciated.

Have a nice weekend!

Newbie

Re: Using current date (TODAY() as macro variable entry for naming a dataset (scripting)

txnelson — Fri, 28 Jun 2019 08:12:44 GMT

The following will create a new table with the name specified as you requested.

New Table("CLASS_" || format(today(),"yyyymmdd"));

Re: Using current date (TODAY() as macro variable entry for naming a dataset (scripting)

Newbie2Jumpie — Fri, 28 Jun 2019 08:15:45 GMT

That's grand, that is!

Thanks a lot, mate!