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.    ... View more

  Merry Christmas to all SAS Visual Analytics fans and I hope you all are doing very well.   Over the years I have done several tips & tricks presentations/demos, especially here in the Nordics. I have created a landing page here on communities.sas.com with my current launched tips & tricks videos, just follow this link: SAS VA Tips & Tricks Series   Here are the current available tips & tricks videos:   How to use custom images in Geographic Maps In this video, we will look at how we can make Geographic Maps more interesting by replacing the standard bubbles with custom images. Click here to view the video…   Simple steps to make your list table shine Maybe you think the list table is a bit boring? In this video we will look at simple steps how to make your list table shine. Click here to view the video…    Tips & Tricks mini-series in four episodes: Why I love working with containers Part 1 - Introduction to the basics of how to work with containers and how I use containers when designing reports and structuring report pages. Click here to view the video… Part 2 - We will take a closer look into how I use containers and container techniques for better design and appearance. Click here to view the video… Part 3 - We will look at how we can re-use containers (or page sections) to speed up report/dashboard development. Click here to view the video… Part 4 - In this last episode I will inspire you by showing some of my design examples I’ve created over the years using containers. Click here to view the video…   New videos will be added, and I will announce them both on communities.sas.com and LinkedIn (linkedin.com/in/carl-olow-magnusson-116a445)   Enjoy and have fun! Kalle ... View more

Merry Christmas,   At some point, it might be necessary to sort a table in SAS VA based on multiple columns. However, it might seem impossible at first, based on the options that the report gives you, by right-click.   The simplest way to fix this, is by pressing the ctrl key and click on the headers of the chosen columns that are desired to sort the data.   May your tables be even more useful from now on!   Were you aware of this feature? And do you have another way to sort your table based on multiple columns?  ... View more

Her er oversigt over/links til 2024 danske og Nordiske FANS Netværksmøder:   AML 21/3-2024   Customer Intelligence:  20/3-2024, 20/3-2024   Data Science/Analytisk: 5/3-2024 29/5-2024   Platform: 28/2-2024 30/5-2025   Programmering: 5/3-2024 6/6-2024   SAS Viya and Microsoft Azure Kubernetes 5/3-2024   Visual Analytics - Link til oversigt-side incl. sparringssessioner: 27/2-2024 7/6-2024   Link til øvrige år oversigter: 2023 2022 2021 2020 2019 ... View more

Oversigt over Visual Analytics Netværksmøder 27/2-24 7/6-24   Visual Analytics Sparringssessioner - Se mødelinks under vedhæftede filer Onsdag d. 31/1 kl. 9 Torsdag d. 25/4 kl. 14 Skriv spørgmål til Sparringssessionerne under "Comments"   ... View more