topic Re: Juletip #6 – Run current datastep or proc with a single keystroke in SAS Community Nordic

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

DanielRingqvist — Thu, 04 Jan 2024 13:06:47 GMT

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.

Re: Juletip #6 – Run current datastep or proc with a single keystroke

PeterClemmensen — Sun, 10 Dec 2023 19:54:11 GMT

@DanielRingqvist , very nice!

Re: Juletip #6 – Run current datastep or proc with a single keystroke

DanielRingqvist — Mon, 11 Dec 2023 08:26:53 GMT

It's a life saver 😉

Re: Juletip #6 – Run current datastep or proc with a single keystroke

ballardw — Mon, 11 Dec 2023 12:40:16 GMT

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.

Re: Juletip #6 – Run current datastep or proc with a single keystroke

DanielRingqvist — Tue, 12 Dec 2023 12:17:57 GMT

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

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

Fabian_Rodrigue — Thu, 23 May 2024 18:45:47 GMT

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