How to check a table is available with macro?

[spyds]

Hi everyone,

Sometimes the Excel extension resources I import are inaccessible due to node error, I want to check if this table is accessible with a macro, otherwise I want to unload this table and load it again with the .sashdat extension.

is this possible?

for example to algorithm(I am a beginner about sas syntax, I gave a general description);
if x table can accessible
   do nothing
else 
   unload x table
   load x table.sashdat

[Tom]

Are you using SAS Add-In for Microsoft Office?

If so are you asking for help with Excel programming? Or SAS programming?

Or are you just using normal SAS to access some type of Excel file, like an XLSX file?

[spyds]

Hi, sorry my explanation is not detailed enough. I am using sas viya and i am accessing some data by importing excel documents instead of database connection. 

Sometimes these datas that i import are not available due to node errors, so i need the solution that includes the algorithm i mentioned upside, thanks.

[AMSAS]

@spyds I'm not clear on what you are attempting to do. 
It sounds like you are asking if there's a way in SAS to identify if a file exists or not - In which case you need to look at SAS Functions (see External File functions) and specifically FILEEXIST Function