SAS DATE ISSUED

[SHESADEV]

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.

[PeterClemmensen]

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

[Kurt_Bremser]

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

[mkeintz]

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;

[SHESADEV]

Thank a lots.
worked it.

[Reeza]

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.