How to execute a MS SQL Server Stored Procedure in VA data preparation? Urgent help please!

[akk]

Hi All,

I attempted to insert results of execute a stored procedure into sas table, but i'm not sure how can i do that.

I'm using SAS VA 7.4

Kindly need your urgent support.
Best Regards,

[SASKiwi]

You can certainly do this in a SAS SQL passthru query. You can run normal SAS code including SAS SQL in SAS VA using SAS Studio which comes bundled in a VA (7.x) installation. You would however need SAS/ACCESS to SQL Server or ODBC installed on your VA platform.