topic Re: Add-In for Microsoft Office: connect to library in Microsoft Integration with SAS

Add-In for Microsoft Office: connect to library

gzr2mz39 — Tue, 05 Jul 2016 18:31:52 GMT

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.

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

Viraaj — Tue, 05 Jul 2016 18:56:00 GMT

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

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

Viraaj — Tue, 05 Jul 2016 18:57:01 GMT

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

gzr2mz39 — Tue, 05 Jul 2016 19:06:47 GMT

Hi Viraaj,

How do you create metadata folders on SMC?

Thank you.

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

SASKiwi — Tue, 05 Jul 2016 20:15:51 GMT

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.

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

gzr2mz39 — Tue, 05 Jul 2016 20:47:24 GMT

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.

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

Viraaj — Tue, 05 Jul 2016 20:50:54 GMT

Yes, you can add the new library same level.

Thanks

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

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

SASKiwi — Wed, 06 Jul 2016 07:18:15 GMT

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#n0l9lj112qvz7tn0z2rzmqui1du0.htm

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