Just if you need it for other situations: filename D temp; proc printto log=D; run; proc cas ; table.Partition/ casout={caslib="mycaslib" name="previous_errors" replace=True} table={caslib="mycaslib" name= "&viewName._DQ" where="DQField= error"}; quit; proc printto; run; data _null_; infile D; input; if "ERROR:"=:_infile_ or "WARNING:"=:_infile_ then put _infile_; run; filename D clear; There is also SYSERR macrovariable which keep info about last error.   Bart   ... View more

Hi both, Thanks for your help. It's an Oracle connection, so should work, but I think as said there just isn't any way of using in 3.5 sadly. I will explore the suggested option of loading it into a SAS dataset first, thanks both. ... View more

Thanks for helping me clarify.   Most of the caslibs are actually connections to Oracle databases. Which makes me think that I should potentially explore using directly querying the Oracle database for any information it holds on the tables, rather than accessing it via the caslib connector? As presumably, SAS will struggle to operate on the tables without loading them first, as they're not currently SAS datasets. ... View more