Generally speaking, you cannot use EXECUTE if you want to feed the resukt back to the calling SAS session.
You have to use the SELECT * FROM CONNECTION TO construct.
But, this uses a query as a parmeter. And id understand TD SP correctly, the result is fed back to avariable, rather than a query result.
So my guess is that this hard to accomplish OOTB.
Workaround? - if you can store the status_var in a table, then query that in a seconf call using SELECT * FROM CONNECTION TO.
... View more