open sas view in excel

[tomrvincent]

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.

[FredrikE]

Jupp, it works, I have a pre-assigned library, it's defined in the autoexec.

[tomrvincent]

I'm guessing you have SAS installed on your PC and am running Windows.

[fifthand57th]

@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.)