Macronot working to workout the latest file (by the date on the end of the file name)

DC2-CJH — Tue, 11 Jun 2019 10:17:55 GMT

Hi all I am trying to import the latest created file by the data at the end of it's name form a location. I have the below code that I am sure used to work but I am now getting an error (also provided below), can anyone assist and tell me what's wrong with the Macro as I can't work it out.

%LET location = \\Drive and file location entered here\file name here;

Code being run

%MACRO get_filenames(location);

filename _dir "%bquote(&location.)";

data filenames(keep=memname SeqNo Extention );

Excel_Dir=dopen( "_dir" );

if Excel_Dir > 0 then

do;

count=dnum(Excel_Dir);

do i=1 to count;

memname=dread(Excel_Dir,i);

SeqNo =i;

Extention = substr(memname,index(memname,".")+1,length(memname));

if Extention = "txt" then

Extention = "txt";

output filenames;

end;

rc=dclose(Excel_Dir);

call symput("MaxID",SeqNo);

call symput("Extention",Extention);

run;

%DO j = 1 %TO &MaxID.;

data _null_;

set work.filenames;

where SeqNo = &j.;

call symput("inputfile",memname);

call symput("Position",(length(memname)-(length(Extention)+1)));

run;

%END;

%MEND get_filenames;

/* Create a stamp (set as todays date) */

DATA _null_;

FORMAT Stamp $10.;

Stamp = put(today(),date9.);

CALL symput('Stamp',Stamp);

RUN;

%PUT &Stamp;

%get_filenames(%bquote("&location."));

/* Select the name of the latest file by the max SeqNo */

PROC SQL NOPRINT;

SELECT compress(memname)

INTO: fileName

FROM filenames

WHERE SeqNo IN (SELECT max(SeqNo) FROM filenames)

;QUIT;

%PUT &fileName. ;

Error I am receiving

ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was:

&MaxID.

ERROR: The %TO value of the %DO J loop is invalid.

ERROR: The macro GET_FILENAMES will stop executing.

Any idea what could be wrong with the above?

Thanks

Re: Macronot working to workout the latest file (by the date on the end of the file name)

DC2-CJH — Tue, 11 Jun 2019 10:22:06 GMT

Don't worry resolved it, thanks

Re: Macronot working to workout the latest file (by the date on the end of the file name)

ChrisNZ — Tue, 11 Jun 2019 10:43:44 GMT

It looks like maxid never gets populated.

so the preceding data step before probably doesn't run as expected.

topic Re: Macronot working to workout the latest file (by the date on the end of the file name) in SAS Programming

Macronot working to workout the latest file (by the date on the end of the file name)

Re: Macronot working to workout the latest file (by the date on the end of the file name)

Re: Macronot working to workout the latest file (by the date on the end of the file name)