It could be really nice if prompts allowed for changing the measures in graphs and tables. For example having a drop-down list with a range of various measures (budget and actual expenses) and choosing one simply changes the measure displayed in the linechart or having a list object with checkboxes allowing to choose which measures are to be displayed in a (cross)table. ... 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

Often times I use the WHERE button in the dataview which works great. It would be very helpful to be able to quickly sort the dataview either in the normal view or while using the WHERE button. This would make validating data much faster than having to create a new query. ... 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

I have some processes that are best performed using hash objects, often ending with use of the OUTPUT method to write results to a data set.  But some of my datasets are so large that the correspondng hash objects need too much memory to run.   However, many of these tasks can be done in BY groups.  Conceptually thiis would suggest using the hash object for one by-group, outputitng the results to a data set, then clearing the hash object, and doing the same process all over again for the next by group, followed by outputing it to the same data set.   But the OUTPUT method would only overwrite the data set.  So I am asking for an APPEND method, which would work similarly to PROC APPEND.  This would allow object-oriented processing of many large data sets with a much smaller demand on memory resources.  ... View more

If there is a list of values (copied from excel or dataset or text file) that need to be used in where condition, strings need to be in quotes separated by comma. How about giving power to Find & Replace in SAS EG (Ctrl+H) like Notepad++ does.   For example I have: Acura Audi BMW Buick Cadillac Chevrolet Chrysler Dodge Ford I want them : "Acura","Audi","BMW","Buick","Cadillac","Chevrolet","Chrysler","Dodge","Ford" Step 1: Open notepade++ and paste the values. Step 2: Remove leading and trailing blanks: Go to edit->Blank Operations->Trim leading and trailing space. Step 3: Put quotes: Open Search>Replace… in Notepad++ (Ctrl+H) Select Regular Expression and in find what add (.+) and in replace what add “\1” and click replace. This will add quotes to the words listed in the file when replaced.     Step 4 Separate by comma: Now in Find what add \r\n and in Replace with add just comma (,) as shown in screenshot.         ... View more

When I make a format, about 99.9% of the time I expect it to be exhaustive of the values that will be encountered.  It would be nice to be able to define a format that would throw an error to the log if a value was not found.   For example:   proc format; value sex 1='F' 2='M' other=_ERROR_ /*pseudo code*/ ; run; data have; input sex ; cards; 1 1 3 ; run;   When the format is used, it would throw an error to the log.  So below PROC step and DATA step would both throw errors, ideally listing the invalid value:   proc freq data=have; tables sex; format sex sex.; run; data want; set have; sexC=put(sex,sex.); run;   I know there are alternatives, e.g., data want; set have; sexC=put(sex,sex.); if sexC="_ERROR_" then put "ERROR: invalid value " sex=; run; But it would be nice to have a way to say when a format is created, "if any value is outside the domain of values defined in the format, throw an error [or warning or note]."   ... View more

    As a SAS Studio user, I want SAS to provide an update to SAS Studio that will make the browser provide notification when a job is complete. This feature is needed to improve the user experience for the SAS Studio product.   Example: Many times we must run programs or projects which take a considerable amount of time to complete. Due to unknowns such as server and database usage, the job may take much longer or shorter. Since SAS Studio does not provide visual feedback on the task bar, the only way to check if anything has changed, is to open the Studio window and visually inspect if it is still running. Many windows applications (including web-apps) provide a blink or highlighting feature on the task bar for the application to indicate something has changed in the application or some input is needed. I would like Studio to implement this sort of 'blink' effect when a job or project run has been completed.   We are currently on 9.4m6, Studio 3.8.  ... View more

I was thinking that a "Run to Selected Node(s)" feature in SAS Enterprise Guide would be an amazing feature just like in SAS Data Integration Studio. The time that I would gain in not having to select all the nodes/task that need to run before a specific node/task in huge process flows would be tremendous... bringing my efficiency level to the top :-).   What do you think about this new feature? A must have or not?   Cheers,   Danny  ... 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

Please allow the syntax   data T1; set A(gennum=174) - A(gennum=187); run; ... View more

Hi,   When selecting cells in a cross-tab, it should be possible to copy the selected cells and paste them elsewhere, e.g. Excel, without having to export the entire table. As it is right now, it is possible for report readers to select cells, thus highlighting the cells in blue, but as far as I know this does not give the user any new options. For me being able to select specific cells gives the reader the impression that it is possible to copy the selected cells, like in so many other programs, only to leave them confused or disappointed. I am currently on version 7.2   - Kasper ... View more

The where functions are perfectly valid so why red?   proc tabulate data=lib.test; class period_end; tables period_end; where period_end > '01jan19'd; run; proc freq data=lib.test; tables period_end; where period_end > '01jan19'd; run; ... 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

If one uses an invalid format in %SYSFUNC, the error can go undetected: %let date=%sysfunc(today(),xxx.); %put &=date.; Log: 69 %let date=%sysfunc(today(),xxx.); 70 %put &=date.; DATE=22602 The %SYSFUNC function should issue at least a NOTE to the log, like the PUT function does: 69 data _null_; 70 x = put(today(),xxx.); ____ 484 NOTE 484-185: Format XXX was not found or could not be loaded. ... 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

When a certain expression is used to create a new variable: create table ouput2 as select put(Team,$Ffmt.) as Team_Category, count(*) as No_Customers and the same expression is used in the group by: group by put(Team,$Ffmt.) the SQL compiler should recognize this and act as if the new variable had been used instead: group by calculated Team_Category and avoid the (accidental) remerging with the original data ... View more

Right now the below code produces CONTENTS output with no variable labels (or, the var names are repeated in the labels, which is about the same).  That's a shame because Teradata has a nice field (and even table) commenting feature that seems to me the exact analogue of SAS' variable labels.   It should be possible to have these labels go into & come back out of the server's metadata tables.   libname td teradata &td_goo ; data with_labels (label = "A nice descriptive label") ; x = "Hey" ; y = "Ho" ; z = "Let's go!" ; label x = "The first word of the chorus" y = "The second word of the chorus" z = "The third word of the chorus" ; run ; data td.labels_gone ; set with_labels ; run ; proc contents data = td.labels_gone ; run ;   ... 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