topic Re: SAS DATE ISSUED in SAS Programming

SAS DATE ISSUED

SHESADEV — Fri, 27 Oct 2017 10:28:02 GMT

Hi All,

I m trying to do sas date function using sas macro and i need below output.

%let a= %sysfunc(intnx(day,%sysfunc(today()),-1),yymmdd10.);

Output

2017-10-26.

but need output should be .

'2017-10-26'

within the code.

Please guide me how would be do it.

Re: SAS DATE ISSUED

PeterClemmensen — Fri, 27 Oct 2017 10:40:10 GMT

data _null_;
   date=today()-1;
   format date yymmdd10.;
   put date;
run;

Re: SAS DATE ISSUED

Kurt_Bremser — Fri, 27 Oct 2017 11:25:59 GMT

Where do you use the macro variable? Depending on the use, both the format and the quotes might not be necessary.

Re: SAS DATE ISSUED

mkeintz — Fri, 27 Oct 2017 11:47:47 GMT

If you have to do this in macro, you could precede and follow you expression with %str(%'), as in:

%let a=    %str(%')%sysfunc(intnx(day,%sysfunc(today()),1),yymmdd10.)%str(%');
%put &=a;

Re: SAS DATE ISSUED

SHESADEV — Fri, 27 Oct 2017 12:35:53 GMT

Thank a lots.
worked it.

Re: SAS DATE ISSUED

Reeza — Fri, 27 Oct 2017 15:25:14 GMT

Personally I'm not a fan of including quotes in macro variables, I prefer to leave them unquoted and then use with quotes as necessary. It makes them more versatile in the long run and allows for multiple uses.