cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
akk
Calcite | Level 5 akk
Calcite | Level 5

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

Posted 09-09-2018 04:10 AM (1486 views)

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,

0 Likes
Reply
1 REPLY 1
SASKiwi
PROC Star SASKiwi
PROC Star

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

Posted 09-09-2018 04:21 AM (1480 views)  |   In reply to akk

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.

0 Likes
Reply

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →
Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Watch Tips for filtering data sources in SAS Visual Analytics on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • ‎09-09-2018 04:10 AM
  • 1487 views
  • 0 likes
  • 2 in conversation