SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

open sas view in excel

Reply
Contributor
Posts: 27

open sas view in excel

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.

Regular Contributor
Posts: 158

Re: open sas view in excel

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

Contributor
Posts: 27

Re: open sas view in excel

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

SAS Employee
Posts: 16

Re: open sas view in excel

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

Ask a Question
Discussion stats
  • 3 replies
  • 181 views
  • 0 likes
  • 3 in conversation