Transcription of 012-2011: Tips and Techniques for Automating the SAS® …
{{id}} {{{paragraph}}}
1 Paper 012-2011 tips and Techniques for Automating the sas add -In for microsoft office with Visual Basic for Applications Tim Beese, SAS Institute Inc., Cary, NC ABSTRACT Do you want to run SAS Stored Processes in microsoft Excel and set the prompt values from your worksheet? Do you want to filter your SAS data sets based on the values of specific cells? Do you want to customize your microsoft office content with buttons and other controls that allow you to open data, run SAS code and refresh results? This is now possible! The sas add -In for microsoft office adds many new features that allow users to interact with their content through Visual Basic for Applications (VBA). Users can insert and refresh data, stored processes, and reports using VBA.
2 In order to use Intellisense within the VBA editor, you must add a reference to the SAS Add-In for Microsoft Office. To do this, select Tools > References.Find SAS Add-In 4.3 for Microsoft Office in the list, and select the check box
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}
Microsoft Office, SAS Add-In for Microsoft Office, WatchGuard and Microsoft Office 365 Integration, Office, Office basics Learning, Office basics Learning Office, Microsoft Outlook 2016, Microsoft, Outlook 2016, Microsoft PowerPoint 2010, PowerPoint 2010, Microsoft Office 2007 WORD Assignments Computers