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.)
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Register now!