Input data for macro code

[David_Billa]

In the below code, I want the macro variable REPORTINGDATE to resolve as 31MAR2007. So I would like to know what value to be passed as Input for the variable x.

data _null_;
x=input(put(&reportingdate,$8.),yymmdd8.);
format x date9.;
call symput('REPORTINGDATE',x);
run;

[PeterClemmensen]

What is the initial value of &Reportingdate?

[David_Billa]

It is coming from batch process.

So you can assign any value

[Kurt_Bremser · Accepted solution]

%let reportingdate=20070331;

data _null_;
x = input("&reportingdate",yymmdd8.);
call symput('reportingdate',put(x,date9.));
run;

Note that in most cases, you won't need a formatted date in the macro variable. For calculations and comparisons, the raw value is easier to handle.

And if you want the date displayed, use a better format like e8601da10. (equal to yymmddd10.).