Regency MX Excel User Manual

1 Paper HOW-004 SAS® Add in to MS Office – A Tutorial Angela Hall, Zencos Consulting, Cary, NC ABSTRACT Business folks use Excel and have no desire t

10 The appearance tab allows users to specify display options. These are specific to the SAS Task selected and the type of display chosen. Titles al

11 OUTPUT OPTIONS From the SAS Menu Bar, Select Options. This GUI provides users with the ability to customize items such as how the data table is dis

12 3. Options – Graph Tab Choose the type and size of display image produced. 4. Options – Task Tab Modify the default footnote.

13 5. Options – Stored Process Tab 6. Options – Advanced Tab The Advanced Options Tab also offers Email settings.

14 INTERACTING WITH OUTPUT By right-clicking on the graph, you can (if using ActiveX or JAVA graphics device driver) do the same tasks as you would

15 By clicking on the last item ‘Properties’ of the above menu, you will then get to the following screenshot. This details the SAS Object properties.

16 3. Properties – Execution Tab Graph (or Data) Refresh defaults for the object. 4. Properties – Appearance Tab The SAS graph settings and formats

17 5. Properties – Advanced Tab Additional properties users can adjust.

18 FORWARDING RESULTS TO OTHER OFFICE PRODUCTS SAS -> Tools -> Send To -> Word/PowerPoint is a option for a SAS Object built through the SA

19

2 SAS ADD IN TO MS OFFICE – MS EXCEL INTRODUCTION Once the SAS Add in has been installed on the desktop, the SAS toolbar (containing buttons for Activ

20 STORED PROCESSES Stored Processes are viewable via the Toolbar button Reports:

21 REFRESHING REPORTS By clicking the Refresh Multiple Button, all the SAS Objects in the Excel Workbook can be refreshed, or you can pick and choose.

22 OUTLOOK INTEGRATION An ‘unsupported’ SAS Feature is that by using Outlook with the Word Editor on for New Messages, the Add in to MS Office add-in

23 MS POWERPOINT The same functionality is now available in PowerPoint – HOWEVER, users cannot open datasets as they can in Excel.

24 REFERENCES Additional tutorials are available from Zencos’ Youtube Channel ZencosTV. http://www.youtube.com/zencostv CONTACT INFORMATION Your com

3 DATA SOURCE OPTIONS When Selecting Data Sources either for use during the Analyze Data task or by selecting SAS->Open Data Source, you have the a

4 QUERYING DATA TABLES As an example, when you open the data source SASHELP.SHOES after choosing Analyze Data, the following screen will appear:

5 You can then filter the data source: … Generates a list of values that corresponds to the Data

6 Select ‘And’, ‘Or’, criteria and the next line will display. Select ‘X’ to delete the line.

7 Simulate a VLOOKUP excel function by pasting in multiple values: Required Option ‘Is in a list of values’

8 ANALYZE DATA The Analyze Data tab goes to a list of SAS Tasks, similar to SAS Enterprise Guide’s Task Menu Bar. Some items will not run if the conn

9 Analyze data tasks are very easy to use, included is an example for generating a BAR Chart. First you select the display type, these are similar to