topic Re: Date in yyyy-mm-dd format by using macro in SAS Programming

Date in yyyy-mm-dd format by using macro

dht115 — Mon, 14 Feb 2022 18:58:34 GMT

Hello,

I do need to change date in YYYY-MM-DD format by using the macro value.

%LET start_date = '01Feb2022'd;
%let start = (&start_date., yymmdd10.);
%put &start.;

start should be 2022-02-01.

Re: Date in yyyy-mm-dd format by using macro

PaigeMiller — Mon, 14 Feb 2022 19:05:15 GMT

The macro processor needs additional instruction in order to work with dates. This is the %SYSEVALF function and the %SYSFUNC function.

Please note for clarity, now and in the future: your title implies you are working with macros. You are not working with macros. You are working with macro variables, which is something different than a macro. Do not use "macro" to refer to "macro variables".

%let start_date = %sysevalf('01feb2022'd);
%let start = %sysfunc(putn(&start_date, yymmdd10.));
%put &=start;

Re: Date in yyyy-mm-dd format by using macro

Tom — Mon, 14 Feb 2022 19:31:13 GMT

No need to add the %SYSEVALF() if you are going to use the value with %SYSFUNC(). Unlike the %EVAL() macro function used for most macro code evaluations the SAS data step functions know how to interpret literals directly.

238   %let start_date = '01Feb2022'd;
239   %let start = %sysfunc(putn(&start_date., yymmdd10.));
240   %put &=start_date &=start;
START_DATE='01Feb2022'd START=2022-02-01

Re: Date in yyyy-mm-dd format by using macro

Reeza — Mon, 14 Feb 2022 19:29:23 GMT

Starting day of month for current month in desired format

 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 SYMBOLGEN:  Macro variable _SASWSTEMP_ resolves to /home/fkhurshed/.sasstudio/.images/9a0e017f-022a-4352-9956-2f959c2997c7
 SYMBOLGEN:  Some characters in the above value which were subject to macro quoting have been unquoted for printing.
 SYMBOLGEN:  Macro variable GRAPHINIT resolves to GOPTIONS RESET=ALL GSFNAME=_GSFNAME;
 68         
 69         %let start = %sysfunc(intnx(month, %sysfunc(today()), 0, b), yymmdd10.);
 70         %put &start.;
 SYMBOLGEN:  Macro variable START resolves to 2022-02-01
 2022-02-01