Analyzing Local Excel Data via SAS Addin to MS Office

With local data highlighted in Microsoft Excel, you can then "Copy to SAS Server" to run SAS analytical tasks. The menu bar ('SAS' -> 'Active Data' -> 'Copy to SAS Server') is also the image below:

SAS provides a knowledge base entry at: to show how this can be done with a SAS query result - writing back to the same source data set.

In EITHER case, you need to have WRITE access to the file space & associated metadata library on the server.

Note: A google search on " "'Copy to SAS Server"" also provides additional information on hotfixes and functionality capable via this menu item.


About Author

Angela Hall

Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.

Related Posts

Leave A Reply

Back to Top