SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Large Query

Reply
Contributor
Posts: 42

Large Query

can someone explain how does the SAS Excel Add-in work as far as loading the data from a large query?  does SAS get the data in SAS dataset format first on the server and then download and convert to Excel format and load in the worksheet?  how to improve the speed of loading a large amount of data on Excel using SAS?  thanks.

Esteemed Advisor
Posts: 5,198

Re: Large Query

If you are working with large data sets and do ad hoc queries a lot, the add in might not be the optimal tool. Enterprise Guide or SAS Studio offers more flexibility and possibilities to optimize and control query behaviour.
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 237 views
  • 1 like
  • 2 in conversation