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 ?
Why not use the fexist() function first to determine if the file exists, and use that as condition?
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 ?
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: