Re: open sas view in excel

tomrvincent · Posted 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.

FredrikE · Posted 09-04-2017 04:34 AM

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

tomrvincent · Posted 09-05-2017 11:33 AM

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

fifthand57th · Posted 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.)