Increasingly, software developers and data scientists rely on LLMs to help with coding, but LLMs are poor at SAS coding. Hallucinations are common, and the LLM-generated SAS code often does not run without major changes. This combination of circumstances may lead to poor outcomes, such as SAS coders who may turn to alternatives like Python which have top-tier support in LLMs, whether used in the traditional dialog format or embedded in coding assistants such as GitHub Coplot and Windsurf.   The academic paper "The Llama 3 Herd of Models" in section 4.3.1 lists their top 10 top-tier languages (notably, not including SAS), and the paper details how Meta improved the ability of LLMs to generate better code. One potential solution to LLMs' struggle with SAS coding is for SAS to emulate Meta's approach by developing a corpus of SAS-specific training data that all LLMs can freely use. Then, SAS could publish this data set on Hugging Face and promote it to Meta, OpenAI, Google, and Claude.   The Llama paper gives a template for this process. In the case of SAS, coding questions and solutions could be automatically collected from resources such as the SAS documentation (example code), this SAS forum, StackOverflow, SAS support cases, and SAS blogs (to the extent permissible by copyrights, licenses, and ToS).  Some strategies in the Llama paper: remove PII, automatically evaluate by LLMs, automatically write unit tests, automatically testing solutions in sandbox environments.   An intriguing strategy would be to develop a list of Python data science and business intelligence question, and then translate the solutions to SAS. This assumes that coders in each language are facing similar questions, but the Python questions are more abundant on the open Internet.  ... View more

While many welcome the availability of SAS EG for connecting to SAS Viya 4 as they see it as a continuity from the past (and carry the historical baggage along with), the availability of multiple interfaces to connect to SAS Viya 4 (SAS EG, SAS Studio, VS Code ) is  chaotic and an avoidable irritant for admins.  In my experience VS Code has proved it's mettle . When it works for   Java, C#, go, python and, C++,   Oracle etc.,  it can work for SAS too as efficiently. It is my humble suggestion that SAS promote VS Code as the official Code editor for SAS/CAS programming and deprecate SAS Studio and SAS EG over a reasonable period of time. This would simplify managing the environment (and make business sense to SAS too!). SAS would only need to focus on extensions. ... View more

It would be highly appreciated if an option is given in the bar graph to resize the Y-axis labels area so that labels are never hidden and replaced by "...". So far it seems that the space allocated for labels and the space allocated for bars is automatically defined by SAS and it happens that labels are hidden when too long (in these cases we would like just to reduce the space for the bars). We provide an example in the picture on how we would like it work. We didn't find any option to avoid this behaviour without having to just reduce the size of the labels. We would like to have this on SAS Viya 4.0. Thank you.     ... 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

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

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

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

It would be nice to be able to copy text from an individual cell in the list table. This is possible in a crosstab but it would be nice to mimic the excel function of copying from a regular table/cell for the list table.  ... View more

The objective would be to have a user scan a mock table shell and then have AI generate the code to fill out the table given an input sas procedure ( e.g. results of proc univariate or proc freq ) .   This would eliminate the need to build table macros  and allow a programmer to be more productive. ... View more

There is any functionality to enable 'CLICK TO COPY TO CLIPBOARD' for transaction fields in SAS FM UI.  Right now Ctrl+C or right click to copy is working. However, its request from business user .   Please suggest   Kindly find the screenshot, transaction file and contents needs to be copied using 'CLICK TO COPY TO CLIPBOARD' instead of Ctrl+C ... View more

Microsoft does have its co-pilot, and there is IntelliSense (code suggestions as you code), but I think there can be something more profound.   Let's call it SAS Guru.   As you are coding in the various interfaces, SAS EG or SAS Studio I think you could score the code (maybe even using some statistics!) and when you find code that seems to be not efficient (such as repetition of terms, profoundly short variable names, lack of comments, lack of coding structures, long procedural style code, etc) you can send badly scored pieces of code in real time to a generative AI sidebar that can make real time contextual suggestions for code enhancements. "SAS Guru: It appears that this function is doing an average payment calculation consider renaming variable "c" to "cAvgPmt" for clarity." "SAS Guru: This code could be rewritten to enhance maintainability by creating variables for these values, and rewriting it with a %do loop, see this rewritten code suggestion...   %do ... "   Similarly, when leveraging a data access method or doing a proc sql / datastep you can send the query / datastep to AI to suggest enhancements.  When you do this though you can send in real time the underlying table configuration, etc, to give the best possible answer, ie. knowing the data types, knowing the database interface, knowing the table structure, understanding context of those structures (to suggest in db analytics) and knowing what is indexed.  (things that a non-integrated AI wouldn't be able to inherently glean) In the same vein it can know when you're merging data between data sources and suggest more optimal ways of doing it.   When code is running you could use AI to give an analysis of the log results or the overall code. (Build information about iterative run and present back that AI generated analysis) "SAS Guru: This run was faster than your last run, on December 3rd at 6am by 18 minutes, that's 10% faster, the performance of all successful runs to date is between 1 hour and 1.5 hours.  Your fastest runs occurred between 5pm and 6pm, and your slowest runs occurred in the mornings.   Your overall program took 45 minutes to run the 4th procedure (PROC SQL - ...) took the longest time (40m), it brought in 100 columns and 1m records, however your program only uses 35 of these columns and 20,000 rows.  (using AI to suggest a resolution)   First Consider Using mod(account_number,50)=0 in the WHERE close to build a sample set without importing all the data.   Next Consider Updating the select with these (...used columns...) will drop your data import by approximately 70%.  Consider moving your 6th procedure into the "whatever database" using this suggested code rewrite, this will save 6 minutes and reduce your data import by 20%.   I'm a performance guy you could definitely use this to suggest parameters to functions, or better functions, etc.   If using AI is a stretch, doing some post analysis/suggestion based on the log (or iterative logs) would be a really nice enhancement. ... View more

What Model Manager is missing Information about the state of the VTA Project configuration (e.g. Concept Definitions) at time of model registration. Once a model is registered, cannot change the VTA project config that feeds that specific model. If a VTA project is changed after the model has been registered, no way to revert state of the VTA project to bring it back to the time of model registration. Ability to generate scoring results in “offset” format (this might be a possibility, but not from what we’ve seen) Would require additional development & processing time overhead to manipulate scored output into a useable format ... View more

Hello everyone One of our main customers complains about the difficulty of reading the name of the reports in the Open New Report window. This is because the "Name" column where we have the list of reports is very small and to find a correct one to open, we have to manually adjust the width of the column. My suggestion is that the "Name" column in the Visual Analytics "Open" window is automatically adjusted in size so that you can see the full name of the reports   Grazie Michele ... View more

Visualisation tools such as Tableau, allow a drop down list that is multi select, and has a text search box within it. Can this be implemented for SAS VA. The current List Control in SAS VA is not design friendly on a dashboard, as it takes up too much space, and cannot be text searched. In Tableau, a dashboard could have 10 or more drop down lists in a small area of the dashboard, because they collapse, and are useful for finding an ... View more