topic How to check a table is available with macro? in SAS Programming

How to check a table is available with macro?

spyds — Thu, 28 Apr 2022 08:41:33 GMT

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

Re: How to check a table is available with macro?

Tom — Thu, 28 Apr 2022 16:08:48 GMT

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?

Re: How to check a table is available with macro?

AMSAS — Thu, 28 Apr 2022 16:22:51 GMT

@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

Re: How to check a table is available with macro?

spyds — Thu, 28 Apr 2022 17:04:17 GMT

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.