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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.