topic Re: If error "physical file doesnt exist" then... in SAS Programming

If error "physical file doesnt exist" then...

John1231 — Thu, 23 Mar 2017 13:49:18 GMT

Hi,

I have a macro which checks if the file exist and if it doesnt i want to append a different data set to another set.

So I have an idea to use syserr option

%if &syserr > 1 %then %do ;

proc append base=base.data data=test_data force;

%end;

but I want to specify that if concrete error occurs "physical file doesnt exist" then the proc append will work.

Is there a such possibility ?

Re: If error "physical file doesnt exist" then...

Kurt_Bremser — Thu, 23 Mar 2017 14:00:52 GMT

Why not use the fexist() function first to determine if the file exists, and use that as condition?

Re: If error "physical file doesnt exist" then...

John1231 — Thu, 23 Mar 2017 14:36:48 GMT

i had a problem with fexist, but i fixed it so it's ok.

but i'm curious, is there a possibility to determine condtional logic based on a specified error ?

Re: If error "physical file doesnt exist" then...

Kurt_Bremser — Thu, 23 Mar 2017 14:57:08 GMT

If you have a code that identifies a specific error, you can use that. But the documentation for &syserr does not show a particular code for "physical file does not exist". So I recommend to check with fexist, as you otherwise might do something unexpected when another error occurs.

Re: If error "physical file doesnt exist" then...

Peter_C — Thu, 23 Mar 2017 23:18:39 GMT

and FILEEXIST()