New idea exchange ideas in SAS Support Communities

Add proc http examples to SAS Rest Api-site for developers

MAGDN — Thu, 25 Apr 2024 14:51:52 GMT

The new (and former) site SAS for Developers does not contain proc http examples when using the rest api's

I think this is a great omission sincs many customers uses this api's from whitin.

SAS option to run from cursor

rsmith1 — Tue, 23 Apr 2024 08:31:52 GMT

Sometimes when a SAS program fails you only want to run from the failing point, it would be nice if there was the functionality in SAS EG to run from where the cursor is to the end of the program. At the moment you have to select the bottom half of the code which is a bit of a faff in a big program.

Git functionality within SAS Studio for Solaris OS

avi77 — Mon, 08 Apr 2024 20:08:51 GMT

Hi Team

We are big SAS customer running our SAS on Solaris OS. Currently GIT functionality with in SAS Studio is not supported for Solaris OS.

We need this feature.

Thank you

Request: Improve Column Insertion interface in SAS-Viya/SAS Studio QUERY

Erik_W — Thu, 04 Apr 2024 19:13:37 GMT

Currently in the SAS-Viya/SAS Studio (Version Stable 2024.02) QUERY interface, it is difficult to control where new columns are inserted in the Query column listing.

The interface is set up for a user to drag a new column from the tables/Columns window on the left into the QUERY>SELECT>Columns Tab on the right for insertion. It highlights the row the user hovers over, but upon insertion, the new column is not inserted there. Instead it shows up at the bottom of the Query column listing. SAS Technical Support informs me this is the "expected" behavior in the current version.

Request:

Please improve this interface to allow users to insert new columns where they are desired in the overall Query column listing. i.e. provide ability to:

- Select where in the column listing to insert new column(s) and put them there when executed.

- Allow selection of multiple columns by holding SHIFT or CNTRL keys and selecting them. Then allow user to drag them to the desired position in the listing.

- When insertion/move occurs, leave the display showing the same section of the column listing so the user can confirm where they went. Currently, when a move is done, the entire listing changes to a different view so you have to go looking for what was done.

Global language setting in SAS VI / LEI

Michael_Steer — Thu, 04 Apr 2024 07:59:00 GMT

Date formatting in SAS VI / LEI is controlled by browser language settings. For example if your browser language setting is English UK then dates will be UK formatted in the UI. Whereas, if your browser language setting is English US then dates will be US formatted in the UI.

Clients don't always have access to change language settings on company laptops and therefore feel it would be beneficial for SAS VI / LEI to have a global language setting in VIYA / Environment Manager that automatically formats all dates to the preferred style of the client.

The disposition list should contain only the button list that authorized by user's queue

Wathana_S — Wed, 20 Mar 2024 11:52:29 GMT

The disposition list on Alert detail screen should contain only the list that authorized by user queue.

For example

The Manager group queue and Manager Employee queue are in the same Strategy. Our user expect that the disposition button list should be displayed only disposition of that user's queue. The attachment is the Manager's screen, our user expect that the gray button will not be displayed.

Allow CAS Server auto-scaling

EyalGonen — Wed, 20 Mar 2024 07:38:31 GMT

Please consider adding a feature to allow CAS server elasticity in the form of auto-scaling for SAS Viya 4

Allow adding a note as metadata on a SAS data file

MattJans — Tue, 19 Mar 2024 19:18:41 GMT

Stata has a very handy documentation/transparency/reproducibility metadata function that allows users to add custom, verbose notes to a data file (as metadata). See more information here: https://www.stata.com/manuals/dnotes.pdf.

As far as I can tell, SAS doesn't do this (can label a data file, but limited space to do so). The maximum length of one note is 67,784 for a single note and multiple notes can be added to a data file (e.g., when doing something to/with it and saving).

The notes are numbered sequentially, so can be used as a change log, e.g.,

1. Saved raw data file after downloading from the web.

2. Created recodes for vars X-Z.

3. Copy of data file used in publication.

See other examples in the link above.

Obviously, this information can be listed in a custom log or in code, but what's better than attaching metadata about a data file to the file itself? Thanks for considering!

View the CDD and AML Alert purpose should be only for review, not for disposition (AML8.3)

Wathana_S — Tue, 19 Mar 2024 11:38:19 GMT

For AML8.3, when the user clicks 'View the alert' to access the alert. The alert cannot be claimed (there is no function to claim/Claim is disable). Meanwhile, the user can click disposition to handle the alert.

So, if the purpose of "View the alert", to see detail inside the alert detail only. Disposition button should be grayed out in case that user click "View the alert" to access the alert.

The restriction on Calendar control on VI10.8 (Review Time Period in AML8.3)

Wathana_S — Mon, 18 Mar 2024 09:41:24 GMT

The calendar control should allows to put the date restriction to display from the current date (VI10.8 Hot Fix6).

Our customer is using SAS AML8.3 with CDD, they specified that on the 'Customer Review' >> 'Review Details' tab, the calendar control in 'Review Time Period' section(in the attached screen) allows user to put the back date which may cause the incorrect date into the system.

Set group restriction on each workflow page on AML8.3

Wathana_S — Fri, 08 Mar 2024 12:49:45 GMT

The system should allow to set the group restriction to view specific active workflow on SAS Visual Investigator Admin according to the data object authorization.

AML8.3 Transaction Monitoring case subcategory not relevant to case category

Wathana_S — Wed, 06 Mar 2024 12:09:10 GMT

In SAS AML8.3, While the user create AML case, Case category should be reflected by Case category.

Have PROC OPTMODEL / PROC ILM offer an option to select which is the solver we want to use

montmar — Tue, 05 Mar 2024 20:12:27 GMT

Hello. When working with PROC OPTMODEL and PROC IML, we're actually working with a solver. Between versions of SAS, this solver is constantly changed for various reasons. When the solver is updated, a problem that works fine with the current version of SAS then no longer works with the new version. Since this is for multiple clients, it is not possible to optimize the solver and please everyone. Would it be possible to add a new option to the PROCS so that when we invoke them, we pick which solver we want to be using? This way, if someone wants a solver optimized, then a new solver would be shipped and they could use it while it would leave all other users stable as they could keep using the solver they were using before. This of course means that SAS needs to ship several solvers but I'm sure it can be done.

Subscribe function in SAS AML8.3

Wathana_S — Mon, 04 Mar 2024 06:47:02 GMT

The subscribe function to send an email notification to user from any actions with their alert, case, customer and report in SAS AML8.3(to be the same with AML6.3) is necessary for our customer.

How to apply a filter in Triage case screen?

Edith1 — Tue, 27 Feb 2024 16:52:55 GMT

On SAS AML on Viya 3.5 how can we apply a filter in Triage case screen.

This functionality is available on Alerts screen. Can you add it on Triage case screen?

Set Check Boxes / Boolean Values in SAS LEI to true

Michael_Steer — Sun, 25 Feb 2024 08:50:21 GMT

In SAS LEI we are using the Tripwire functionality. One of the OOTB fields for this entity is called Generate Email which is a Boolean field. On the LEI page template that we have designed for our client the end user is required to check the box to either true or false to request the required email.

This field is displayed on the page template as a check box with the pre determined value of false. The client is requesting that this check box is automatically checked to true from the outset rather than the end user having to check the box.

From conversations with Tech Support and R&D we know that this is not possible within the current solution and have suggested a feature request whereby the person building the SAS LEI configuration can set the Boolean value / check box to either true or false when designing the page template.

Preserve date of modification when a file is copied through SAS Via interface

Florimond — Thu, 15 Feb 2024 16:21:16 GMT

When we copied/paste a file from SAS Viya, the modification date is the creation date of the new file,

Is it possible to have at least 'creation date' and 'modification date'

Or is possible to not change the date of modification when copied files ?

SAS EG Editor needs improvement

Jerry_B — Tue, 13 Feb 2024 19:33:25 GMT

The SAS EG editor, where I spend most of my day, could be much improved. I'd like to make the following suggestions to make my work easier and more efficient:

When opening a file in SAS EG, it doesn't use a standard Windows file open dialog box. Instead, you must first select from Recent, My Computer, Servers, etc. If you select My Computer or Servers, you then need to select the folder. It should just open to the last accessed folder with one click. Making all of these selections every time is annoying and unproductive.
Because it does not use a standard Windows file dialog, the folder of the file you are editing is not displayed, but it should be.
Since you have the ability to open local or remote files, it would be very helpful if you had a window similar to WinSCP, enabling easy file transfer between your local machine and a server.
In the log window, clicking on Errors, Warnings, or Notes does not correctly subset the list below to display Errors, Warnings, or Notes.
Block copy (Alt + left mouse button + drag) does not work correctly (as it does in Notepad++).

You can't create a block past the end of a line - you need to insert spaces first, or you will have a jagged left edge to your selection. SAS should automatically insert spaces to match the width of the selection or the line above.
You can't select a vertical line and begin inserting characters. If you want to insert a vertical block of text, you need to insert it one row at a time manually. This functionality is very easy in most editors and would save me a lot of time.

When performing a replace in a selection of text, the replace dialog should stay open and the selection stay selected so that you can make another replacement without having to re-select the text.
It would be nice if you could easily flag a row by clicking in the left margin, similar to what you can do in Notepad++, so that you can easily find that row again after scrolling up or down.
It would be helpful to have a count of the number of rows selected at the bottom of the screen, like in Excel, so that you can easily count code lists and the like.

Add external object reference in Flows by relative path in SAS Studio

MattMaj — Fri, 09 Feb 2024 14:15:53 GMT

If an external object (f.e. Custom Step) is added to the Flow then it is referenced by the full path. We would like to reference it by a variable or relative path like "../../Prompts.step" instead. This functionality constitutes the Git integrability and allows for a simultaneous work of more than 1 person while keeping the project in the Git.

We would like to see a following set up – each developer works on own local repository. Inside a repository we have number of Flows. Some Flows in a folder contain Custom Steps.

One developer changes something in such Custom Step and commits the changes. Other developer clones the repository and tries to change the same Custom Step. Dev2 is now unable to save it, because the path of the Custom Step points to dev1’s local repository. It means that even though the Flow is in repo2, the object inside (Custom Step) is from repo1. The path to DEV1's repo is visible if we hover over opened inside object from DEV2's Flow.

It is like this:

We want it to be like this:

Now we have to remove the Custom Step from each Flow and attach the new version, then select every custom option inside. It takes a lot of time, since one Custom Step can be in more than one flow. To solve this we could include objects with relative path (f.e. ../../Prompts/1_Prompts.step) or variable (f.e. ${path}/Prompts/1_Prompts.step) so it works across repositories. We don’t want to keep those Custom Steps outside repository as there is no DI’s check-out option and anyone could change the code of the Custom Step anytime.

recording - ref: CS0060147

Proc Download to Windows Share Drive in SAS VIYA

gm7 — Thu, 25 Jan 2024 14:49:01 GMT

With all these changes around SAS needs to be innovated in order to stay competitive with this market and make SAS Viya more competitive tool with the other firms by producing Excel report with Jobs Flows and scheduling jobs that has dependance.

It would be a great idea and invention, if you ask your engineer to add this functionality PROC DOWNLOAD Statement into SAS VIYA, that will allow Developer to send excel files directly into windows share drive, in addition to sending file into Unix.