topic Re: Input data for macro code in SAS Programming

Input data for macro code

David_Billa — Thu, 14 Nov 2019 07:45:27 GMT

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;

Re: Input data for macro code

PeterClemmensen — Thu, 14 Nov 2019 07:49:38 GMT

What is the initial value of &Reportingdate?

Re: Input data for macro code

Kurt_Bremser — Thu, 14 Nov 2019 07:54:27 GMT

%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.).

Re: Input data for macro code

David_Billa — Thu, 14 Nov 2019 08:13:23 GMT

It is coming from batch process.

So you can assign any value