topic Get today data in SAS Programming

Get today data

sathya66 — Mon, 13 Jul 2020 12:35:12 GMT

can't get todays data.Please help.can we not call global macro in data step?

data a;
infile cards;
input test$ date anydtdte.;
format date yymmddn8.;
cards;
a 20200713
b 20200713
c 20200707
d 20200708
e 20200709
uf 20200710
;
run;
%let today = %sysfunc(today(),yymmddn8.);
	%put "&today.";

data test;
set a;
if date=&today;
run;

Re: Get today data

andreas_lds — Mon, 13 Jul 2020 12:53:51 GMT

In most cases it is not a good idea to store formatted dates in macro-variables. This is one of those cases.

In a data-step a format has no influence on the value stored in the dataset, the format only influences what you see.

So please try:

data test;
  set a;
  if date = today();
run;

If you really need today's date in a macro-variable don't use the second parameter of %sysfunc:

%let today = %sysfunc(today());

Re: Get today data

ketpt42 — Mon, 13 Jul 2020 12:59:06 GMT

SAS is not recognizing your macro variable &today as a date. It is recognizing it as the number 20200713. Remove the format in your %sysfunc(today()) step, and it will return the number of days since 1/1/1960, which is 22109. SAS will recognize that as your date.

data a;
infile cards;
input test$ date anydtdte.;
format date yymmddn8.;
cards;
a 20200713
b 20200713
c 20200707
d 20200708
e 20200709
uf 20200710
;
run;

%let today = %sysfunc(today());
    %put &=today;

data test;
set a;
if date=&today;
run;

Re: Get today data

Kurt_Bremser — Mon, 13 Jul 2020 13:07:44 GMT

See Maxim 28.

Re: Get today data

rabindrakumar1 — Mon, 13 Jul 2020 13:17:54 GMT

Hi,

Please use the date format while defining the macro:

%let today = %sysfunc(today(),yymmddn8.);
%put date=&today;

And then when you are creating the dataset A, you have to mention the codition with input statment, because now the macro value is character and you are filtering the data as date value which a different datatype.