tomweber-sas
commented
2 years ago Hey @Debbby57 sorry I wasn't able to get to this today. You are correct that sd2df() with a non-existent table won't cause the SYSERRORTEXT auto macro to have an error in it. That's because saspy checks to see if the table exists before trying to access it and if it doesn't exist, it returns None, along with the error message that the table doesn't exist. So, there's no code submitted to SAS that would fail and generate an error in the macro variable. There are a couple ways you can programmatically check for this kind of issue in your code already, so that you can return your own error. You can use the exist() method to see if the table exists or not (same as sd2df does under the covers) or you could check the returned variable from sd2df, which is a SASdata object if successful, or None if not (the case here). The SAS auto macros, like SYSERRORTEXT are not populated by saspy, but rather SAS, so for things where saspy catches a problem and never submits code to SAS which would error, those macro variables aren't populated since there wasn't a SAS error (no code ran that caused an error).
Here's some example code you could integrate into what you have above; use exist() to see if the table you're trying to access exists, or check what you get back from sd2df to see if it worked or not:
>>> df = sas.sd2df('tom')
The SAS Data Set .tom does not exist
>>> df
>>> type(df)
<class 'NoneType'>
>>> df is None
True
>>> sas.SYSERRORTEXT()
''
>>> sas.exist('tom')
False
>>>So, for instance:
with my_session as sas:
table = 'mytable'
sas.submit("data {}; set my_source; run;".format(table))
my_table_df = sas.sd2df(table);
if sas.SYSERRORTEXT() or not sas.exist(table):
raise Exception("SAS LOG ERRORS : " + sas.SYSERRORTEXT())
or you could do:
if sas.SYSERRORTEXT() or my_table_df is None:
raise Exception("SAS LOG ERRORS : " + sas.SYSERRORTEXT())
Both of those will return the exception you have coded.Is that a reasonable way for you to programmatically check for this kind of situation? You can't only count on the SAS macro variables for all cases as they are only for errors that happen in SAS itself.
Thanks, Tom
Galileo-Galilei
Debbby57
Is your feature request related to a problem? Please describe. Hello !
I have the code below :
If I make a mistake in the sas submitted code (for example," my_source" doesn't exist so I can't create "my_table"), I have a SAS Code Error.
But if I make a mistake in the SAS Tablename when I use the sd2df function (for example, "my_table" doesn't exist), SAS doesn't return a code Error. The log indicates
The SAS Data Set work.my_table does not existbut the sas.SYSERR() returns 0 and the sas.SYSERRORTEXT() is empty.Describe the solution you'd like I would like to have a SAS Error because I may not use my_table_df immediatly but I prefer to stop the python script immediatly since it's going to crash anyway.
Thank you :)