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

Add-In for Microsoft Office: connect to library

Accepted Solution Solved
Reply
Regular Contributor
Posts: 195
Accepted Solution

Add-In for Microsoft Office: connect to library

[ Edited ]

Hi,

 

I have a libname in SAS that points to a library called '/sasdata/opsupport/'.

The library is located on a SAS 9.4 server.

How do I navigate to this library in the Add-In for Microsoft Office?

I'm unable to locate the library under SAS Folders and Servers. 

 

Thank you.


Accepted Solutions
Solution
‎07-06-2016 05:52 PM
Respected Advisor
Posts: 3,063

Re: Add-In for Microsoft Office: connect to library

For your LIBNAME to be available in Excel, it needs to be set up so it is run automatically whenever a SASApp session is started. The easiest way to do this is by creating it as a Data Library in SAS Management Console:

 

http://support.sas.com/documentation/cdl/en/bidsag/68193/HTML/default/viewer.htm#n0l9lj112qvz7tn0z2r...

 

You could also put the LIBNAME in a SAS AUTOEXEC program but that is trickier to set up. 

View solution in original post


All Replies
Occasional Contributor
Posts: 8

Re: Add-In for Microsoft Office: connect to library

Hi,

 

Here we have two options to access the tables via SAS  MS Add-in.

 

1. Metadata 

2. Application server (physical tables libraries)

 

Metadata: you need to create the metadata folders on SMC. So that all user can access this metadata folders via SAS MS add-in.

 

I have attached the screen shots of both in SAS MS Add-in.

 

Thanks

 

Attachment
Regular Contributor
Posts: 195

Re: Add-In for Microsoft Office: connect to library

Hi Viraaj,

How do you create metadata folders on SMC?

Thank you.

Occasional Contributor
Posts: 8

Re: Add-In for Microsoft Office: connect to library

 
Attachment
Respected Advisor
Posts: 3,063

Re: Add-In for Microsoft Office: connect to library

Click SAS Data on the SAS ribbon. This opens View SAS Data, click Browse to go to Open Data Source.

 

Select Servers, double click on your SAS Server name (maybe SASApp) and it should expand to show all of the server LIBNAMEs. 

Regular Contributor
Posts: 195

Re: Add-In for Microsoft Office: connect to library

Under SASApp I see the following libraries: maps, mapsgfk, mapssas, sasapp-sasdata, sashelp, sasuser, stp samples, and work.

I don't see anymore levels under these folders.

If I don't see the libname I'm looking for how would I go about adding it?

 

Thank you.

Occasional Contributor
Posts: 8

Re: Add-In for Microsoft Office: connect to library

Yes, you can add the new library same level.

Thanks

##- Please type your reply above this line. Simple formatting, no
attachments. -##
Solution
‎07-06-2016 05:52 PM
Respected Advisor
Posts: 3,063

Re: Add-In for Microsoft Office: connect to library

For your LIBNAME to be available in Excel, it needs to be set up so it is run automatically whenever a SASApp session is started. The easiest way to do this is by creating it as a Data Library in SAS Management Console:

 

http://support.sas.com/documentation/cdl/en/bidsag/68193/HTML/default/viewer.htm#n0l9lj112qvz7tn0z2r...

 

You could also put the LIBNAME in a SAS AUTOEXEC program but that is trickier to set up. 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 964 views
  • 0 likes
  • 3 in conversation