topic Re: SAS Add-in lost with 9.4 install in SAS Programming

SAS Add-in lost with 9.4 install

podarum — Thu, 07 Sep 2017 19:16:22 GMT

Base 9.4, I lost the Excel Add-in feature (needed to connect to SAS datasets)... anyone ideas how to get this? or if it's avaialble yet?

Thanks

Re: SAS Add-in lost with 9.4 install

Ron_MacroMaven — Thu, 07 Sep 2017 19:29:20 GMT

this program will show what you have licensed.

options linesize=max
        pagesize=max;
proc setinit;
run;

hth

Ron Fehd which? maven

Re: SAS Add-in lost with 9.4 install

ballardw — Thu, 07 Sep 2017 19:32:48 GMT

And this program shows what you have actually installed.

proc product_status;run;

You may need to share the results of both programs. You may have been licensed for the addin but it may not have been installed properly. Or it wasn't included in the license.

Re: SAS Add-in lost with 9.4 install

podarum — Thu, 07 Sep 2017 19:39:51 GMT

Here's what I got:

Original site validation data

Current version: 9.04.01M4P110916

Expiration: 29SEP2017.

Grace Period: 30 days (ending 29OCT2017).

Warning Period: 30 days (ending 28NOV2017).

System birthday: 23NOV2016.

Operating System: WX64_WKS.

Product expiration dates:

---Base SAS Software 29SEP2017

---SAS/STAT 29SEP2017

---SAS/GRAPH 29SEP2017

---SAS/ETS 29SEP2017

---SAS/FSP 29SEP2017

---SAS/OR 29SEP2017

---SAS/AF 29SEP2017

---SAS/IML 29SEP2017

---SAS/ASSIST 29SEP2017

---SAS/CONNECT 29SEP2017

---SAS/EIS 29SEP2017

---MDDB Server common products 29SEP2017

---SAS/Secure 168-bit 29SEP2017

---SAS/Secure Windows 29SEP2017

---SAS Enterprise Guide 29SEP2017

---OR OPT 29SEP2017

---OR PRS 29SEP2017

---OR IVS 29SEP2017

---OR LSO 29SEP2017

---SAS/ACCESS Interface to PC Files 29SEP2017

---SAS/ACCESS Interface to ODBC 29SEP2017

---SAS/IML Studio 29SEP2017

---SAS Workspace Server for Local Access 29SEP2017

---SAS/ACCESS to Hadoop 29SEP2017

---High Performance Suite 29SEP2017

*************

For Base SAS Software ...

Custom version information: 9.4_M4

Image version information: 9.04.01M4P110916

For SAS/STAT ...

Custom version information: 14.2

For SAS/GRAPH ...

Custom version information: 9.4_M4

For SAS/ETS ...

Custom version information: 14.2

For SAS/FSP ...

Custom version information: 9.4_M4

For SAS/OR ...

Custom version information: 14.2

For SAS/AF ...

Custom version information: 9.4_M4

For SAS/IML ...

Custom version information: 14.2

For SAS/ASSIST ...

Custom version information: 9.4

Image version information: 9.04.01M0P061913

For SAS/CONNECT ...

Custom version information: 9.4_M4

For SAS/ACCESS to Hadoop ...

Custom version information: 9.44

For High Performance Suite ...

Custom version information: 2.2_M5

For SAS/ACCESS Interface to PC Files ...

Custom version information: 9.4_M4

For SAS/ACCESS Interface to ODBC ...

Custom version information: 9.4_M4

Re: SAS Add-in lost with 9.4 install

ChrisHemedinger — Thu, 07 Sep 2017 19:55:36 GMT

The SAS Add-In for Microsoft Office is a separate install, not an automatic part of Base SAS. You (or your IT admin) will need to install the SAS Add-In via the SAS Deployment Wizard. Or, the SAS Add-In has a nice standalone installer that you can find in your software depot (again, your admin might need to help).

If you once had the product activated on this machine, but are afraid something has changed to "lose" it, you might check your /Program Files/SASHome/x86 directory to see if the bits are there. If so, you might be able to reactivate from a command prompt using the SwitcherUtility that comes with the product.

Re: SAS Add-in lost with 9.4 install

podarum — Thu, 07 Sep 2017 20:03:38 GMT

If you mean SAS Deployment Manager .. this is what I can see. Where can I find the Add-in?

Re: SAS Add-in lost with 9.4 install

ChrisHemedinger — Thu, 07 Sep 2017 20:13:11 GMT

No -- the Software Deployment Wizard is the setup.exe that you find in your software depot, a (usually very large) directory with the installation media for your SAS products.

Within there, you can also find the standalone installer (named something like SASAddInForMicrosoftOffice71_x86_x64.exe). That might be a better option if you're not having to configure a full SAS environment.

All of this assumes that the product is part of your software order. SAS Add-In is bundled with several solutions but it's not automatically included with Base SAS.