Hi @ballardw, This is what I have been using to import the file right now. But I am not able to read the invoice number. data _null_;
day=today();
call symput("begmnth",put(intnx("month",day,-8,'b'),date9.));
run;
%put &=begmnth.;
filename invoice "&path./invoice_&begmnth.*";
proc import out= want
datafile=invoice dbms= xlsx replace;
startrow=3;
Sheet = 'Sheet1';
Getnames = No;
run;
... View more
