We have reformulated and renamed the communities-based board where you can enter your suggestions to improve SAS products. Read all about this change in the announcement -- and keep those great suggestions coming!
Create parameter enabling export cross table with the same design of the original SAS Visual Analytics to Excel.
Often users need to edit the data in Excel, while preserving the same design from the SAS.
Thanks.
... View more
SAS Institute-supplied functions allow optional parameters:
A=substr(B,2);
It would be very useful that custom-built functions have the same ability.
... View more
There is still no way to stop a program from executing further statements except by killing the session by aborting it.
Many years ago I kludged together a workaround, but I reckon a proper way to stop a program without generating an error or aborting the session is needed.
... View more
Hi,
I cannot understand why SAS Enterprise Guide 8.3 has lost the RUN command on the context menu in the SAS Code node.
In SAS Enterprise Guide 7.15 and SAS Studio 3.8, the right-mouse click menu in the SAS Code node both contain a Run command, like this:
So now we've got all modern and adopted SAS Enterprise Guide 8.3, can we please have our old RUN command back ? I know a group of currently aggrieved users, and one particularly grumpy one, who will be much happier for its return.
Cheers,
Down Under Dave
New Zealand
... View more
Provide one warning when a string longer than 28 characters is given as input to a sheet_name or sheet_label option. Suggestion:
WARNING: Sheet tab name(s) over 28 characters long will be truncated.
Related Forum posting: "Excel sheet name length limit"
... View more
It would be nice to have some dark or customizable themes for SAS Studio. Since it works in the browser some browser extensions can be used, but having customizable settings in the IDE would help for programmers moving from other IDE's.
... View more
I'd like the ability to edit non .sas files in the SAS Studio editor. e.g.
.txt
.sh
.php
etc...
Also, the ability to "save-as" as non .sas file would also be welcomed.
... View more
Currently when using the autoname option it adds a prefix to the end of the variable name.
It would be helpful to have an option to add it to the beginning of the name instead. Depending on the type of analysis this can be important to later use variable shortcut lists appropriately.
There are currently many ways to accomplish this but it would be a nice to have feature/option to do this automatically.
... View more
To show missing values as NA, it would be nice if we could do the following. It's easy to workaround this, but given that NA is common in other packages this would be a useful addition.
options missing='NA';
data class;
set sashelp.class;
if age=12 then call missing(age, weight);
if age=13 then call missing(height);
run;
proc print data=class;
run;
... View more
We have thousands of Statistical Process Control charts in SAS Visual Analytics that are controlled by many different controls. Many of our business partners that consume these charts often save the chart and add it to an executive summary in PowerPoint. We would really like to be able to pass categories and dates into the title of the chart itself. For example: Chart Title = "p Chart - [dynamic category value] - Baseline set to [Dynamic start date values] to [Dynamic end date values]". These dynamic values could come from a Calculated item or variable in the dataset. The values should be controlled by the controls and interactions.
... View more
Recently it has come to my attention that the SAS UE VM can run out of space in /tmp permanently, as revealed here: https://communities.sas.com/t5/SAS-Analytics-U/How-to-clear-up-space-in-WORK-folder/m-p/337139/highlight/false#M5431
I am really surprised that SAS has not implemented a mechanism that cleans up any remnants of crashed previous workspace server sessions when the VM starts (which is basically a system boot, I think).
So I suggest that at least running the cleanwork utility is implemented at startup of the SA UE VM.
... View more
This would give us, the longest, shortest, and list of values by group.
proc sql;
select longest(STR)
, shortest(STR)
, list(',', quote(trim(STR)))
, listnodup(',', quote(trim(STR)))
from TABLE
group by ID;
quit;
... View more
I've received multiple requests on how to disable the involuntary zoom in and out of a chart that happens when a user is viewing a report. Sometimes it happens because they need to scroll down but the mouse is still on the chart and then they zoom in and struggle to get back to where they were. I'm wondering if there is a way to disable it as an admin.
... View more
We are interested to see SAS z/OS 9.4 provide technology support for new-function added with IBM z15 Integrated Accelerator for Z Sort (new SORT LISTS / SORTL instruction.) Please click LIKE / VOTE-UP for this ballot item, or contact your SAS sales or product manager directly to voice your enterprise's interest with adding ISV-interface support for Z Sort functionality, new with the IBM z15. Benchmark performance-improvement results with native IBM DFSORT SORT execution, where compatibility is exploited, have demonstrated up to 50% CPU-time reduction and also some improved elapsed time. IBM has communicated that ISV-interface support is available as well, but this technology-extension requires significant ISV R&D effort. While some IBM technical documentation mentions that "IBM is currently working with Independent Software Vendors (ISVs) to take advantage of the new feature as well", it is evident that SAS INSTITUTE is looking to customer-input for direction with prioritizing new-function support. Scott Barry SBBTech LLC
... View more
It would be nice if the scrollbars (both vertical and horizontal) in the Code and Log tabs in EG 8 were as wide as the scrollbars in EG 7. See attached.
... View more
SAS currently has a PROC S3 that can do simple upload/download of files from Amazon S3 buckets.
It would be much more useful if SAS would introduce and S3 filename engine also. That way SAS code could read/write directly from the S3 bucket without having to first download the files to local disks.
Syntax might use the same options as are currently used on PROC S3. The PROC S3 options look like this:
FILENAME fileref S3 "path"
<AWSCONFIG="AWS-CLI-file-path">
<CONFIG="file-path">
<KEYID="AWS-key-ID">
<SECRET="AWS-secret">
<NOSSL>
<REGION=AWS-region>
<PROFILE="profile-name">
;
Then a program that could read from S3 might look like this:
filename mydata s3 "/mybucket/mydata.csv" config='~/.ssh/mybucket' ;
data want ;
infile mydata dsd truncover ;
input a b c $ d ;
run;
It would also be helpful if this could be combined with the ZIP and ZIP GZIP engines so that compressed files could be read or written directly to S3 buckets. Similar to how the COPY and UNLOAD commands in Amazon's Redshift database can read and write from and to compressed text files. Perhaps a separate S3GZIP engine could be designed to support that?
... View more
It would be extremely useful to allow a control object with a date measure be allowed to push the selected value into a parameter and be used to create advanced filters. For example, I have a history table which shows changes in parameters by date. I would like the user to be able to go back in time and show all the most recent parameters on a given date. So the user would select a date, which would filter the history table for parameters <= than selected date, but that resulting table would then have to filter for max(date) grouped by parameter_id.
... View more
We have been generating reports in VA (6.3) and for some of those reports we simply would like to embed them in an iframe so our other applications can display them in various contexts. Would be even better if sections of the reports could be pulled separately.
Is there a way SAS can implement this?
Note: Previous version 6.2 seems to be able to do that. Rendering in VA must have changed. From users perspective this seems like a feature taken away with 6.3.
... View more
The current Replace dialog is only regex search.
The text matching the regex pattern is replaced with the Replace with field literally.
The dialog should be improved to handle regex replacement as well. Replace with: would allow find capture groups to be referenced as $1, $2, $3, etc
For example, suppose I want to add square brackets around a sequence of consecutive digits.
Named capture groups should also be supported. For example:
Find: (?'digitrun'\d+)
Replace: [${digitrun}]
The issue of no captures in replacement goes back to at least May 2017. See this post in communities
Because EG uses Enhanced Editor, the improvement should carry over into Windows SAS DM sessions. If regex search and replace feature is not part of SAS Studio editor then that editor should be improved as well.
... View more
