topic Programming Help in SAS Programming

Programming Help

kumarsandip975 — Wed, 26 Apr 2023 06:15:49 GMT

data _null_;
informat lastDayofTheLastMonth yymmddn8.;
lastDayofTheLastMonth=intnx('month', today() , -1, 'E');
put lastDayofTheLastMonth;
call symput('lastDayofTheLastMonth1',lastDayofTheLastMonth);
run;
%put &lastDayofTheLastMonth1;

data have;
INFILE 'Path\ScannedFiles_&lastDayofTheLastMonth1..txt' delimiter=',' dsd;
input var1 var2 var3;
run;

I need to replace lastDayofTheLastMonth1 as yyyymmdd(e.g 20230331) in infile statement, when I am running above code, it's not resolving, kindly suggest.

INFILE 'Path\ScannedFiles_20230331.txt' delimiter=',' dsd;

Re: Programming Help

Kurt_Bremser — Wed, 26 Apr 2023 06:27:08 GMT

An informat only influences what happens in an INPUT statement, it does not affect the value stored in a variable.

Your task can be done in a single %LET:

%let lastdayofthelastmonth = %sysfunc(intnx(month,%sysfunc(today()),-1,e),yymmddn8.);

Re: Programming Help

s_lassen — Wed, 26 Apr 2023 07:13:00 GMT

Apart from what @Kurt_Bremser wrote, your code as shown will not work anyway. When you have your macro variable right, the line

INFILE 'Path\ScannedFiles_&lastDayofTheLastMonth1..txt' delimiter=',' dsd;

should be changed to

INFILE "Path\ScannedFiles_&lastDayofTheLastMonth1..txt" delimiter=',' dsd;

as macro variables inside single quote are not resolved.