09-01-2017 02:38 PM
Anyone know if it is possible to open a SAS view in Excel? I know the view has a libname in it and there doesn't seem to be a way to issue a libname statement in the Excel add-in. Just curious.
09-11-2017 09:20 AM
@tomrvincent The latest version (7.14) of the SAS Add-in for MS Office has a "Program" button on the SAS ribbon that allows you to submit SAS code directly from Excel. See this blog post: http://blogs.sas.com/content/sasdummy/2017/05/30/sas-programs-amo/
If you need this functionality, we highly recommend that you upgrade to 7.14. (Note: SAS Admins can deny this capability in metadata.)