12-08-2016 03:53 AM - edited 12-08-2016 04:09 AM
Write and submit SAS code directly from MS Office documents by using the new SAS Program Editor for MS Office. Using the Program Editor, you can define a LIBNAME, write a program, submit the code, and manage the results within MS Excel, MS Word and MS PowerPoint. You can also open an existing SAS program. When you run the SAS program, the results are added to the specified location in the Office document.
The Program Editor includes
An example from MS Excel is presented below. The example displays that Denmark has seen a year over year growth in both credit card transactions and turnover during the Christmas month the last 8 years – happy shopping everyone!
Example: Program Editor in MS Excel
For more information see ”Help for SAS Add-In for Microsoft Office” in the software
12-08-2016 04:07 AM - edited 12-08-2016 04:09 AM
If you want to see a live demo of the new SAS Programming Editor in Excel then join the webcast to all Nordic SAS users on the 14th of December. We will demo this and other new features in SAS 9.4 M4 - the new SAS version.
Sign up for the webcast here.