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.
Jupp, it works, I have a pre-assigned library, it's defined in the autoexec.
I'm guessing you have SAS installed on your PC and am running Windows.
@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.)
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Latest Updates