If macro variables could be set to default values before prompting, that would allow for complex scenarios.   For example, on the first week of the month, set &begin_date and &end_date to the first and last days of the previous month, but on subsequent days of the month, set &begin_date and &end_date to the first and current days of the current month. ... View more

to this dropdown menu, add those 2.  This would help with reports that are run for the previous month.   ... View more

Editor's note: this suggestion relates to the SAS code that is generated when you create a date prompt in SAS Enterprise Guide (project prompts or SAS stored processes).   I think it's a bug, but SAS may consider it a 'feature'...but when you specify a date as a month, you get this:   16         %LET Rcv_Date_min_end = 31Mar2018; 17         %LET Rcv_Date_max_end = 31Mar2018; 18         %LET Rcv_Date_min_label = Previous month; 19         %LET Rcv_Date_max_rel = M-1M; 20         %LET Rcv_Date_min = 01Mar2018; 21         %LET Rcv_Date_max = 01Mar2018; 22         %LET Rcv_Date_max_label = Previous month; 23         %LET Rcv_Date_min_rel = M-1M;   So why is the max date the same as the first of the month?  uh...no.  Line 21 should be this:   21         %LET Rcv_Date_max = 31Mar2018; ... View more

Instead of just metadata, allow any dataset to be used to populate dynamic dropdowns. ... View more

Be able to do a global search and replace with a project, going across all programs and flows. ... View more

In Enterprise Guide, the notepad with the running man (the sas programs) should be color configurable. The process flow grid in enterprise guide has a configurable background color already which is a less useful feature than I'm proposing here.   Allow the user to select a background color of their SAS program icon.   Allow me to color code this and step 1 to show they go together but don't follow the normal process flow ... View more

I would like to nominate something to be on the SAS ballot.  I want SAS to print out the effect size for any t-test or ANOVA and anything else they want.  I know that it is possible to calculate or program this ourselves, but a lot of people who publish in the applied fields are not up to doing this.  If SAS were to print it, then more people who publish in the applied fields would be more likely include this when they report statistics (nothing is guaranteed, but I think this would help a lot).  Both the American Statistical Association and the American Psychological Association have recommended this practice instead of only reporting P values which get misinterpreted as effect sizes which they most definitely are not.  If SAS were to do this, then it would move the reporting of statistical results forward.  ... View more

I'd like to have process flow A kick off process flow B when it's finished. ... View more

NOTE 49-169: The meaning of an identifier after a quoted string   WARNING: The quoted string currently being processed has become more than 262 characters long   This bug has been around so very long.  Why can't SAS EG clear the buffer and continue?  Or identify where the problem starts?  Why do we have to close SAS EG completely and restart in order to debug this problem? ... View more

We should be able to read and write Access using ODBC or some equivalent on Linux.  There are other ODBC drivers available for Linux for other products. ... View more

We can specify a range when importing from excel but we need a named range defined within the worksheet to be able to write to it.  That should be fixed. ... View more

When we download and install a new SAS upgrade, we point our users to a test set of libraries and the new SASHome USS filesystem for testing.  When we want to deploy the new SAS upgrade into production, we need another SASHome copy that will point to the production high level qualifiers for the datasets and the new directory for the production SASHome.  In other words, I need 2 copies of a SASHome, one for production and one for initial install / testing.  This is a shared sysplex, and we are sharing the SASHome filesystem across all LPARs. SAS support has provided me with what I need to update within the MVS datasets and which files to update within the uss filesystem. Although this is a complete list, I find the manual updates error prone and time consuming.     I would like to request a rexx or job to be provided for these updates to the uss filesystem. It should have the flexibility to change only the MVS high level qualifier or only the SASHome directory or both.   ... View more

PROC OPTIONS displays far more options than PROC OPTSAVE is able to save.  PROC OPTSAVE will not save options that can only be specified at startup.     However, it's helpful at times ( e.g. when comparing SAS Server configs when migrating servers ) to save all options in a dataset.  The alternative is parsing the log output created by PROC OPTIONS.   Two potential solutions: allow PROC OPTSAVE to capture all options in the OUT= dataset add OUT= to PROC OPTIONS  ... View more

It would be nice to have color gradient that can be used in all type of charts. It will be nice feature to show variance. Since right now its possible only in limited charts like, Heat map Geo map (with the Color role assigned) Bubble plot (with continuous data assigned to the Color role) Network diagram (with the Node Color or Link Color role assigned) Word cloud (with the Color role assigned) Treemap (with the Color role assigned)   http://support.sas.com/documentation/cdl/en/vaug/68027/HTML/default/viewer.htm#p1m7j9y6bezv98n11fu8j...   https://communities.sas.com/t5/SAS-Visual-Analytics/Customized-Data-Ranges-and-Color-Gradients/m-p/436429#M9450   ... View more

It would be quite helpful to be able to access Graphic Designer while running SAS University Edition on a MAC. Thanks. ... View more

It would be wonderful if you could have SAS tell you the half width of a confidence interval for a proportion if given a coverage probability, true outcome proportion, and sample size in PROC POWER ONESAMPLEFREQ. This would be useful for choosing a sample size for a single-arm clinical trial.   Example code:   proc power; onesamplefreq ci=wilson /* or exact, wald, etc. */ halfwidth = . /* want to solve for this! */ proportion = .5 .7 .85 ntotal = 25 50 75 probwidth = .95; run;     ... View more

Currently, the Java/C++ score code generated by SAS Enterprise Miner can only be deployed to Windows/Linux/MacOS environments.  More and more applications are being hosted on Mobile platforms (iOS, Android), and the ability to score data locally and instantaneously on a mobile device is highly desireable.  Consider offering score-code libraries that can be run on Android and/or iOS. ... View more

(edited)   I learned the concept of collating in computer science classes, yet SAS help uses the word "interleave".  Nothing wrong with this, but for me and others that learned "collate" rather than "interleave" it would be nice to include this word in the help file, I think.  My ideal edit to the help file would be:   Example 2: Interleaving SAS Data Sets   To interleave, or collate, two or more SAS data sets, use a BY statement after the SET statement: data april; set payable recvable; by account; run;   Maybe, in the future, this will help someone else find this feature of the SET statement faster through a Google search for "SAS collate".   link: https://en.wikipedia.org/wiki/Collation   ... View more

When running PROC TRANSPOSE on a wide dataset that is sparse, it would be nice if the output could be filtered so rows with zero values, e.g., are excluded.   This sample does what I want, but I'd like to add something like an "if value <> 0" or "where value ne 0" to the proc transpose, so the output is limited to rows where value is not zero. Otherwise the resulting output will be huge, especially if I have about 50 "key" columns in the input and millions of records to transpose.   data sample_data; input id $ a b c d e f g; datalines; 01 1 0 0 0 0 0 0 02 0 1 0 0 0 0 0 03 0 0 -1 0 0 0 0 04 0 3 0 0 0 0 0 05 0 0 0 0 0 0 5 ; proc sort data = sample_data; by id a b c d e f g; run; proc transpose data = sample_data out = sample_transpose(rename=(_NAME_=key COL1=value)); var a b c d e f g; by id; run;   ... View more