topic FILEEXIST vs SLEEP in SAS Programming

FILEEXIST vs SLEEP

Jaheuk — Tue, 21 Feb 2012 15:00:38 GMT

DATA

_NULL_

;

fex=

;

DO UNTIL(fex=1

) ;

if %sysfunc(fileexist("C:\temp\fix.txt")) then fex=1

;

else x=sleep(5

);

END

;

RUN

;

hi guys,

when file exist at start, it works!

why does this NOT work when the file does not exist and is created during the sleep loop?

it looks to me that fileexist is only executed once??

Regards,

Herman

Re: FILEEXIST vs SLEEP

Haikuo — Tue, 21 Feb 2012 15:21:43 GMT

When the file does not exist, your code will enter infinite loop, cause always fex=0. If file exists, yes, fileexist will exexute once, since there is no set statement, data _null_ will only run it once, no implied loop here.

Also, don't understand why you use %sysfunc, it seems to me unnecessary here, unless you need to deal with macro variables.

Regards,

Haikuo

FILEEXIST vs SLEEP

Jaheuk — Tue, 21 Feb 2012 16:51:55 GMT

indeed it will go into a loop UNTIL the file is present in the folder, I'd hoped !!

FILEEXIST vs SLEEP

Tom — Tue, 21 Feb 2012 16:54:05 GMT

SAS might have optimized your test out of the loop.

Try putting the filename in a variable so that SAS compiler doesn't view it as a constant.

FILEEXIST vs SLEEP

Astounding — Tue, 21 Feb 2012 17:56:14 GMT

Herman,

The comments you've received are on the mark. %SYSFUNC is not part of the DATA step. It merely determines what statements appear in the DATA step. So the DATA step sees:

if 0 then fex=1;

else x=sleep(5);

Creating the file will not change these statements, so SAS ought to cut short on the looping. But removing %SYSFUNC might do the trick.

Good luck.

FILEEXIST vs SLEEP

SASJedi — Tue, 21 Feb 2012 22:31:36 GMT

As others have said, you need to get the %SYSFUNC out of this code - it is not necessary. You also do not need the variables FEX or X. On my Windows system, this sample code worked just fine:

DATA _NULL_;
   DO UNTIL(fileexist("C:\temp\fix.txt"));
      call sleep(5);
   END;
RUN;

FILEEXIST vs SLEEP

FriedEgg — Wed, 22 Feb 2012 16:33:48 GMT

On unix you would want to alter this just slightly since the default time setting for the sleep function is different than under windows (millisecond on unix vs. second in windows).

data _null_;

do until(fileexist("/temp/fix.txt"));

call sleep(5,1);

end;

run;