Re: SAS DATE ISSUED

SHESADEV · Posted 10-27-2017 06:28 AM

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 · Posted 10-27-2017 06:40 AM

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

The DATA to DATA Step Macro
Blog: SASnrd

Kurt_Bremser · Posted 10-27-2017 07:25 AM

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

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

mkeintz · Posted 10-27-2017 07:47 AM

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;

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

SHESADEV · Posted 10-27-2017 08:35 AM

Thank a lots.
worked it.

Reeza · Posted 10-27-2017 11:25 AM

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.

SAS DATE ISSUED