Interact, learn and grow

Join Now
Reply
This is an open group. Sign in and click the "Join Group" button to become a group member and start posting.
Highlighted
SAS Employee
Posts: 24
SAS Juletip #6 – Write and submit SAS code directly in MS Office - what a Christmas gift from R&D!
[ Edited ]

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

 

  • a color-coded, syntax-checking SAS language editor for editing new or existing SAS programs.
  • auto completion,
  • automatic formatting,
  • pop-up help, and
  • parenthesis matching.

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!

 

The feature above is part of the newly released SAS version 9.4M4 – you can find more information on the release here and where we will post more information here.

 

Merry Christmas

   Jeppe

 

Example: Program Editor in MS Excel

Juletip_6_SAS Program Editor in MS Excel - Eksempel, Dankort omsætning og transaktioner.PNG

 

For more information see ”Help for SAS Add-In for Microsoft Office” in the software

Juletip_6_Add-In for MS Excel - SAS Help.png


Juletip_6_SAS Program Editor in MS Excel - Eksempel, Dankort omsætning og transaktioner.PNG
SAS Employee
Posts: 373
Re: SAS Juletip #6 – Write and submit SAS code directly in MS Office - what a Christmas gift from R&
[ Edited ]

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.

 

Georg

 

SAS Employee
Posts: 10
Re: SAS Juletip #6 – Write and submit SAS code directly in MS Office - what a Christmas gift from R&

Good tip - thanks Jeppe!

 

Best regards,

Petri