Text Analytics is handled by other SAS technologies:
For example, SAS Visual Data Mining and Machine Learning has some procedures for text mining and SAS Studio has tasks for them in Viya.
The SAS Add-In must be licensed.
If the SAS Add-In has been installed and configured correctly, you should see the SAS tab in Word, Excel, SharePoint, Outlook, PowerPoint. It is possible to have the license but not have it installed, and for it to be installed but not correctly or completely configured. In these cases, you would not see the SAS tab.
Please check your SAS licenses to verify if you are licensed for the SAS Add-In for Microsoft Office.
We suggest Googling error messages and also searching communities.sas.com, then contacting SAS technical support if neither of the first two methods resolves your error message.
An editor macro is a series of Program Editor commands and instructions that you group together as a single command to accomplish a task automatically. Instead of manually performing a series of time-consuming, repetitive actions, you can create and run a single macro. You run the macro by using a keyboard shortcut.
Once you’ve invoked the SAS Add-In via the SAS button on the top toolbar of any Microsoft Office technology, click on the SAS Programs icon. This feature was added at version 7.13.
The SAS Programs capability was added at version 7.13. If you are running a prior release, you will not see the Program window.
Depending on your license, it may only allow the SAS Add-In to be invoked from Excel. Some Enterprise Miner licenses have this constraint. Please check with your SAS administrator to verify your SAS licenses, installation and configuration.
Please contact your SAS administrator to verify the installation and configuration.
Yes, if you have the appropriate SAS/ACCESS product licensed, installed, and configured, you can read/write that same data via the SAS Add-In for Microsoft Office.
SAS can conduct read and write operations from and to Microsoft Access, just as it handles all data sources and targets. Microsoft Access data can be handled via ODBC connections or from the ‘Open SAS Data’ operation. As a reminder, the SAS Add-In for Microsoft Office is surfaced through these 5 Microsoft interfaces: Excel, Outlook, PowerPoint, SharePoint, and Word.
The recipient who does not have the Add-In licensed, installed and configured will see a static version of the report.
Yes, you can use Outlook. The functionality in Outlook is more restricted because it’ inappropriate to conduct data management in Outlook. You can access reports, run them, share them, etc.
SAS Add-In for SharePoint requires installation and configuration of SAS Web Parts for SharePoint http://support.sas.com/software/products/mssp/index.html
SAS Enterprise Guide is not required for refreshes. As long as the SAS Add-In is correctly installed and configured, the Refresh button will refresh the report.
Yes, you can run SAS tasks, procedure, and functions on Excel data.
Yes – either by saving to a library or the Upload to Server task.
There is no limit.
First, verify that the SAS Add-In is included in your license. If you do have it licensed, then IT could install and configure it for you.
The environment can be set up that way, though that is not common with the SAS Add-In in a production environment. It is more common to connect to a genuine multi-user server.
Yes, you should be able to run the stored process. You should check to make sure that your stored process is properly registered in SAS metadata, and that the SAS Add-In correctly installed and configured (you should see SAS in the upper toolbar of Excel, Outlook, PowerPoint, SharePoint, and Word.
SAS Add-In for Microsoft Office will be seen as a SAS tab in Excel, Word, and PowerPoint. - open one of these clients in order to access your stored processes. You may also try to find/open/run your stored process via SAS Enterprise Guide. See if any of your colleagues can view their own and others’ stored processes.
SAS does not impose any limits. If you encounter Excel limits, then the remaining data will be added to another worksheet.
If the user has SAS Add-In correctly installed and configured, then the capability exists to refresh the data using the current version of the data. You can set a document to be refreshed when opened or you can manually refresh it.
You can check to see if the SAS tab shows up in the banner of your Microsoft client, plus confirm your SAS licenses with your administration team.
Having technologies correctly installed, configured and maintained are key. Testing the same operations in Enterprise Guide can help troubleshoot the SAS Add-In. We suggest Googling error messages and also searching communities.sas.com, then contacting SAS technical support if neither of these prior methods resolves your error message.