Add-In for Microsoft Office: connect to library

[gzr2mz39]

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.

[Viraaj]

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

[gzr2mz39]

Hi Viraaj,

How do you create metadata folders on SMC?

Thank you.

[Viraaj]

[SASKiwi]

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. 

[gzr2mz39]

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.

[Viraaj]

Yes, you can add the new library same level.

Thanks

##- Please type your reply above this line. Simple formatting, no
attachments. -##

[SASKiwi · Accepted solution]

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.