Using Windows Authentication to SQL Server from SAS is a very popular authentication mechanism and it is not possible using CDE with Remote Data Agent. Please consider adding this useful feature. It is important for customers migrating from on-prem to cloud deployments. ... View more

Create a custom shortcut in Enterprise Guide 8.4 to "Send to Microsoft Excel"? You have to go to "Share"...Output Data... Send to Microsoft Excel. It would be nice to just use a shortcut or create a custom button to do this. ... View more

Request: Please can SAS include the option to calculate test statistics for the unadjusted and stratified MN method.   Background: Miettinen-Nurminen (MN) methods are increasingly being requested by regulatory agencies. This is particularly relevant for non-inferiority trials where it's appropriate for the variance to be estimated under the null hypothesis. Within the PROC FREQ procedure, it's currently possible to calculate the treatment differences (and CIs) for both the unadjusted MN and the stratified MN methods as well as other MN tests such as the Summary Score method (also referred to as Agresti Score). However, whilst for the Summary Score method SAS allows the option to calculate the test statistics this is not yet available for the unadjusted MN method or the stratified MN method.   These methods are important as they estimate variance under the null hypothesis, specifically the test statistics are of particular useful for: testing superiority and presenting a p-value studies with interim analyses, particularly when multiplicity is controlled via a group sequential design i.e. with alpha boundaries less than the typical 1-sided 2.5%/2-sided 5% alpha Example SAS code (for reference): Note: data not supplied due to proprietary nature, however code shared to illustrate current options/limitations.  The unadjusted MN treatment difference can be calculated using: proc freq data=DATA; tables TRT*AVAL / riskdiff(CL=(MN) noninferiority margin=0.1);  run; Note: whilst the (unadjusted) Wald test statistics are calculated, it would be helpful if the unadjusted MN test statistics could also be provided. The stratified MN Score treatment difference can be calculated using: proc freq data=DATA; tables STRATA*TRT*AVAL / riskdiff(CL=(MN) noninferiority margin=0.1) COMMONRISKDIFF(CL=(MN score) test=(score)); run; Note: whilst the (adjusted) Summary Score (also referred to as Agresti Score) test statistics are calculated, it would be helpful if the stratified MN test statistics could also be provided. Specifically, if MN could also be an option within COMMONRISKDIFF(TEST=( )) ... View more

PRX-functions (prxmatch(), prxparse(), etc) that deals with regular expressions still cannot process multi-byte character sets like UTF-8 in the SAS 9.4 releases. It is an essential feature that would facilitate a lot a migration to a MBCS context. ... View more

  Hi Community experts,    SAS has a good Social Network Analysis and optimization engine  and Social Network Analysis on SAS Visual Investigator as well. However, some custom semantic queries and pattern matches are hard tasks to be develop directly by business users.   Neo4j had the some barrier with cypher but now they are now integrating a Natural language interface using generative AI using OpenAI ChatGPT. https://neo4j.com/labs/neodash/2.4/user-guide/extensions/natural-language-queries/   Other vendors are also working other similar use-cases like text-to-SQL Databricks https://www.databricks.com/product/databricksiq and IBM WatsonX in Analytics Fields: I https://www.ibm.com/br-pt/products/watsonx-bi-assistant.   I have some customers interested in those features and facing Neo4J competition in our customers. I am working on a project developing this integration with SAS Viya 4, but it will be incredible if we could generate a syntax to semantic queries and pattern match in Network Analysis as a feature by design of SAS SVI or SAS network Analysis make easier to end users to get information for your graphs structures. Looks a very interesting use case of generative AI.   ... View more

I know this has been suggested before, but the issue was closed. (https://communities.sas.com/t5/SAS-Visual-Analytics/Mouse-wheel-graph-interaction/td-p/435358) We are about to publish reports for a big number of users with low computer experience. Using VA is a very small part of their daily job. To educate them all on how to avoid unintended zooming in graph objects, is not a feasible task. A possibility to deactivate mouse wheel zoom would be a great increase in usability for our VA reports, and massively reduce our support burden. I really hope you can consider implementing this soon. Thanks in advance. ... View more

Data Driven Content objects are not only used for visualizing data. They are also the key to innovative ways to select/subset what data to display in the report. (For example the TreeSelector). Therefore it would be very useful if DDC objects could be used exactly as Control object, including being put in the reports controls area and the page controls area of the report. Implementing this would really be a game changer for us. ... View more

Our users are often not very impressed with the reports me and my colleagues make for them. The reason is that they only see the first tab of the report. The tabs are so subtile that the users don't even see them. It's also hard to see which tab is selected. Please make it possible to style the tabs so that we can make them "pop" more.   Picture to show what I mean: Picture of "invisible" tabs in a VA report     ... View more

I have a bunch of SAS files in a directory, that I'm running using sas-viya at the command-line with. Here's the command line I use:   sas-viya batch jobs submit-pgm --context default --wait-results --pgm basic_digits.sas   I have two product suggestions that would reduce some friction:   First, I end up with a bunch of JOB folders with undistinguished names. For example here are three in the folder right now: JOB_20240510_011340_087_1 JOB_20240514_201600_284_1 JOB_20240514_202431_319_1   Without going inside of them... which of those was used to run basic_digits.sas, which was used to run advanced_digits.sas, and which was something else?   I would like to be able to provide a parameter to sas-viya that adds something after the JOB_ , and a way to default to having the name of the SAS program there. I would like something like "--results-dir-prefix" that would create this: JOB_basic_digits_20240510_011340_087_1   I *could* create one "output_{}" folder for each file and use "output_basic_digits" with --dir flag, but I wish for something where I don't have to modify the command line in two places for each job with different filenames [high susceptibility to human error]. You could also use the job name from --job-name, but that still suffers the "two command line edits" problem.   Second, "--context default" shouldn't be necessary. If one doesn't provide the context, it should use the default.   Thank you, Gary ... View more

Starting with SAS Viya version Stable 2024.05, PROC PRINT will now display an empty table in the Results window if the source data set has 0 rows. This is a change from previous versions going back to SAS 9. Prior to this change, running PROC PRINT from a data set with 0 rows sent no output to the Results window.   Some users generate "check" data sets in their code that create rows of data and display results only if something unexpected has happened. This recent change in SAS Viya 2024.05 now causes "false alarms" to go off in previously stable code, as results are now generated from empty data sets.   Although this new behavior can be avoided by adding extra code to check the number of rows in the data set prior to running PROC PRINT, end-users' code would be less impacted if an option was added to allow the user to decide if results should or should not be generated when the source data set has 0 rows. Please consider adding such an option. Thanks! ... View more

We are using SAS94M8 on Linux Grid platform.   As part of a project we would need to connect to  Teradata Vantage on GCP. Part of this migration will change the way clients use to connect to Teradata from LDAP to SAML based federated authentication approach. Can this feature of SAML based federated authentication be enabled or released for SAS94M8?   Documentation for configuring federated authentication on Teradata.   Configuration for Browser Authentication • Security Administration • Reader • Teradata Online Documentation | Quick access to technical manuals   End users would only need to provide the DSN name and the logmech (BROWSER or EXTERNALBROWSER) to connect to the database.  Teradata support the BROWSER mechanism on Windows and Mac OS only. ... View more

In large enterprise organizations, it would be beneficial to be able to hide, or make visible, folders from the SAS server files that are mounted from the Studio Explorer pane based on the groups the users are in.   See Case: CS0115567 for the original support question and example. ... View more

There should be an option to visualize data from two different tables into a single plot without having the need to join those tables. It should work by just mapping the connection between the two table. Why not join? Because join may create issues if the data is at a different hierarchy/ granularity level. ... View more

As discussed with the customer, the user need to add/edit some information related to the closed alert. Anyway, in SAS AML8.3 the system does not allowed user to edit the comment of closed alert. Please help to consider to add the function of 'add/edit comment to alert after the alert is closed' into SAS AML8.3   Thanks! ... View more

Refer to SAS AML8.3, the system is only allow the user to perform any actions on the most recent snapshots (SFEs) for the suspicious activity that has been discovered. This is not allowed the user to add/edit the information of the previous alert. This affects the work process of user as below 1) If the user record the wrong investigation or need to re-investigated the information in the previous alert. 2) The user need to see the attachment in alert level   So, the expectation from the customer are 1) When the new Alert is generated, the user should be able to ‘Edit’ some information in ‘the previous Alert’ such as.. ‘Rate productivity’ to put the comment (in Fired Event Level) for that alert 2) The user can distinguish between the attachment of alert level ... View more

This is a suggestion example. ... View more

Hi, I think it would be beneficial to have Generation Data group like dataset in SAS similar to the format used in Mainframe. Generation Data Groups (GDGs) are group of datasets related to each other by a common name. The common name is referred as GDG base and each dataset associated with the base is called a GDG version. You can set the limit of the related files(generations). We can easily keep track of all generation of data sets. Any particular generation can be referred easily. We use lot of datasets which regenerates daily , monthly , yearly etc..   Consider I need to create daily transaction data for the month of May. If Generation Data Group is available, I would define the base like "Tran_May2024".  Then I would just create dataset daily in the below way.   Data Tran_May2024(+1); -- This will create the next available version.  set work_tran_table; run;   If need to point current or earlier version  i would use the dataset below. Tran_May2024(0) - Latest Version  Tran_May2024(-1) - Previous Version  Tran_May2024(-2) - 2 versions back   If I need the whole month data ,  i just refer the base    Data work_tran_may; set Tran_May2024;   --This would all the version available in the base  run;   you can have options like below   LIMIT – To limit the maximum number of generations.   NOEMPTY – Uncatalog only the oldest generation in GDG when the limit is reached. EMPTY – Uncatalog all the generations when a limit is reached. SCRATCH -Physically delete the dataset(generation) which is uncataloged. NOSCRATCH – Don’t Physically delete the dataset(generation) which is uncataloged.   This would help a lot when we create lot of datasets which are created in a repeatable fashion.    Thank Ravi                ... View more

We are currently using SAS Visual Forecasting for a large-scale forecasting project.  In this project we are using the interactive modeling node to develop custom models.  We have observed in this node that there are almost no options for exploring relationships between your dependent variable and exogenous features.  This makes it very hard to determine which factors to add to the models and in what way to transform them while adding (lag/numerator/denominator).  We would like to see additional visualizations added to the product to allow us to experiment with X/Y transformations, view cross series plots, and explore relationships between the data across different points in time (Cross Correlation Function Plots).     SAS Forecast Studio has these capabilities, however that functionality does not appear in the SAS Visual Forecasting product.    We are on the following version of SAS Studio: Stable 2023.12  ... View more

We are heavily leveraging the Interactive Modeling Node within SAS Visual Forecasting to develop custom models for a large-scale forecasting project.  The Hierarchical Forecasting Node allows the user to generate OUTEST and OUTCOMPONENT files that can be used to understand which features are used in the models and how they influence the final predictions.  Unfortunately, the Interactive Modeling Node does not have the option to export these datasets.     In order to build trust in the models we have developed, we need access to these files.  Can you please help us by adding this capability into a future release of SAS Visual Forecasting?     I am currently on the following version of Model Studio: Stable 2023.12   These options appear as "Parameter Estimates" and "Model Forecast Components" within the Output Tables settings for Hierarchical Forecasting.      ... View more