Juletip #8 – Run current datastep or proc with a single keystroke

[DanielRingqvist]

If your datastep code or Proc SQL (or any Proc) is more than a page, perhaps several pages, it’s pretty tedious to select all code before you can submit. I have an SQL that is 4 pages long myself... There is a nice solution to this in SAS Studio on Viya 4 as well as in SAS Enterprise Guide and DMS (Base SAS).

In SAS Studio you right mouse anywhere in your datastep/proc and select Run Region, and that “region” is submitted. It has the shortcut key Shift+F8 by default, and you can change this in Options > Manage Keyboard Shortcuts.  

In SAS Enterprise Guide and DMS you have to create a “Keyboard macro”. You can export this Keyboard Macro as a .kmf file and give to others so it's easy to share, and I'll share mine right now. You can get this kmf file below in the ZIP SelectCurrentCode. Unzip and click (Import...] in Program > Manage macros and snippets and after importing you assign it to e.g. F8. So having assigned SelectCurrentCode to F8 you would do F8 and then F3 to select the current datastep/proc and run it. How nice is this!? The title says "a single keystroke" but it's actually two, but still... 😉

The KMF file works for DMS as well. Images below just show EG though. 

[PeterClemmensen]

@DanielRingqvist , very nice!

[DanielRingqvist]

It's a life saver 😉

[ballardw]

In DMS at least, this will include any block of comments before the collapsed section. And leave them collapsed in the editor.

Not a deal breaker but is occasionally annoying as I figured this out in SAS 8.

Cntrl-Alt - (minus on the numeric keypad) will collapse all code in the editor in DMS so is handy for submitting two or more blocks (data step or procedures) easily.

[DanielRingqvist]

Yes, comments will be selected lines as well. Does not bother me much though 😉

[Fabian_Rodrigue]

¡¡¡WOW!!! Thanks a lot. 🤘