SASware Ballot Ideas - Page 8

mhamlett · ‎05-17-2016

want ability to add a text box and enter static words and sentences interlaced with token variables. ie. The highest hourly sales for your restaurant on [tokendate] was [tokensalesamount]. This is [tokenpercent] above last year.

Keyur12 · ‎06-05-2020

Can you add something like, if we add ? before the function, it opens the help doc in result viewer. The help doc should give brief description of what the function is, what are the required arguments and optional arguments and brief description of arguments. For example, If i write ?strip(), it will open the document with description of what strip does and all required and optional arguments. This can be done for procedures too, For example, ?proc import, this gives brief description of proc import, required/optional arguments/options. I have seen something like this in R-studio.

mad_scientist · ‎04-26-2016

Users love having the latest SAS Enterprise Guide versions, with all the bells and whistles. But their IT department can be slow to provide deployments of the latest upgrades. This is because some enterprises have multiple SAS platforms, and complex user and deployment environments, which give rise to compatibility issues. These issues need to be dealt with before an upgrade deployment can occur. So IT either spend a long time resolving the issue, or stick with an older version (defer the upgrade). SAS could assist enterprise IT departments provide upgrades more quickly and cheaply by including a 'Save as type' selection within SAS Enterprise Guide, allowing users to save their projects to work with previous versions of SAS Enterprise Guide. This would be a similar function to Microsoft Word, where the Save as type option allows users to save as *.docx, Word 97-2003 etc.

bbenbaruch · ‎06-12-2019

PROC FREQ is a core procedure. It ought to be possible to display MISSING values at the bottom of the output rather than at the top (without creating a NOTSORTED format for every single variable!). I frequently want to see -- and report -- cumulative frequencies of the non-missing values before seeing the impact of the MISSING values on the distribution of my nominal variables. It is a big pain-in-the-bottom to not be able to put MISSING values at the bottom. I am suggesting a BOTTOMMISS option -- or perhaps a NOPAININTHE option -- for the FREQ (and TABULATE) procedures. Example: PROC FREQ DATA=DATA1 ; TABLE V / MISSING NOPAININTHE ; RUN ; v1 Freq % CumFreq Cum% CAT1 274,948 19.31% 274,948 19.31% CAT2 6,663 0.47% 281,611 19.78% CAT3 196,687 13.82% 478,298 33.60% CAT4 560,603 39.38% 1,038,901 72.97% CAT5 299,029 21.00% 1,337,930 93.98% Missing 85,753 6.02% 1,423,683 100.00%

JoeRotford · ‎07-27-2018

Often when developing a project using Query Builder, occasionally you have to go back a few steps and remove a variable. It would be helpful to have the option to also remove the variable upstream if desired. Or a prompt/message box telling you where it is used and lets you choose to remove it from those locations if desired to.

ChrisNZ · ‎12-13-2016

The datetime output is identical to that of the E8601DTw.d format except for the T separator. "yyyy-mm-dd hh:mm:ss.ffffff" instead of "yyyy-mm-ddThh:mm:ss.ffffff" A format generating the same output for date (and time?) variables would be useful too as some tools like Impala can only use timestamps, not dates. I know this can be done using a picture format. Doing so makes the code a lot less portable though.

PoX · ‎02-19-2014

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.

dylanleong78 · ‎05-21-2021

In previous versions of Enterprise Guide, we were able to split our workspace horizontally or vertically (similar to EG 8.2). However, we were also able to set which is the primary window where any programs/datasets that open will be displayed. In complex EG projects where there are multiple Process Flows and within each flow, multiple programs and outputs, navigating them was extremely easy in EG 7 and below. I can double-click on any Process Flows and it will replace the previously opened Process Flow on the top horizontal workspace. I can then proceed to go through various programs/data sets in the Process Flow and these will open in the workspace below which is defined as the primary workspace. Everything makes sense. Now in EG 8.1 and above, Process Flows are opened in the same workspace as programs. A new program will cover up the Process Flow and I will have to select the flow again to navigate around. I then try to set up a split horizontal tab. Unfortunately, every time I open a program or data set, it ONLY opens in the first horizontal tab. I then have to manually move it to the bottom tab. This is extremely counter-intuitive. The Process Flow should drive the navigation and have a dedicated window for them. Furthermore, SAS Programs now default to a horizontal/vertical split of Code (top/left) and Log/Result/Output Data (bottom/right). This view barely works when you only have a single workspace. If you have a horizontal split, opening a program results in 3 horizontal splits! You barely have space for anything. When I am writing hundreds of lines of code, I want full visibility of my code. I don't care about my Logs until I run my code. Previous versions of EG worked very well. Now I have to manually move the Code tab down to the Log/Result/Output data tab. But if I open another program, it gives me the same view yet again! Extremely frustrating trying to do proper programming work in this new interface. I suspect EG 8 will forever be in the same category as Windows 8 in my mind. If the original interface was not broken, don't try to fix it!

Joulin · ‎02-10-2016

For Z/OS system, I can create a physical file compressed with SMS. The physical file store the SAS database. If i compress the file with Zedc feature (Zip compression code) i save more than 88% of disk space and lot of CPU because i remove SAS compression. My problem is the SAS database on this compressed physical file is not a recognized SAS structure file. To use this file, i have to code LIBNAME xxxx V9SEQ engin, so i have to change all SAS programs who use this SAS database. I believe, it is a good idea if you determine that the file is compressed with Zedc (very easy) you use automaticaly the good SAS Engine. Thanks

ksi · ‎11-01-2016

Currently in SAS Studio, under Preferences -> Editor, there is an option for font size but not the font typeface. It would be great if the user can change the font type face. The current font is a bit too thin. I prefer Consolas. P.S. I did not find SAS Studio to be an Idea Label so I listed this under SAS Visual Analytics. Please move this if not in the right category. THanks.

MichelleHomes · ‎01-23-2016

As per my comment to the article, How to make sure SAS Visual Analytics end users understand report interactions, it would be helpful if the suggested information page with report context AND a visual representation of the interactions was autogenerated and updated as the report is changed. Thanks, Michelle

Trey · ‎04-01-2015

As a heavy macro programmer, it would be very helpful if macro variable references had their own syntax highlighting rules. Currently macro variable references are considered macro text within a macro definition, and I think they are considered normal text outside of a macro definition.

Martin_RBV · ‎08-17-2022

Request to SAS: Update the RTF-Output template in such a way that it will be easily possible to insert PAGAE breaks and not (only) SECTION breaks, or at least SECTION breaks that completely comply with the format of SECTION breaks generated by Microsoft Word so that they can be modified/replaced by standard procedures in MS Word. Thanks.

Arjan_tC · ‎04-06-2021

Hello SAS community, I am currently working on a SAS VA dashboard and in this dashboard I make use of a stacking container. I have some tabs with content created and now I want to make it possible to jump to the first tab again, instead of clicking back to the first tab. Is there a possibillity to do this? Or can this only be achieved by selecting 'restore to default report state'? Hope somebody comes up with a solution... Regards, Arjan ten Cate

ChrisNZ · ‎02-05-2019

Following from thread https://communities.sas.com/t5/SAS-Programming/Optimize-SAS-Code/m-p/532716#M145990 When SAS sees this code: data CLASS(index=(AGE)); set SASHELP.CLASS; run; proc sql; select * from CLASS where AGE=12 or (AGE=11 & NAME='Alice'); quit; it decides to not use indexes (because the OR operator is used). It would of course be beneficial that only ages 11 and 12 be selected using an index, and then the NAME filter applied.

PhilC · ‎01-23-2020

The Recent Locations section of the save as window in EG8, (windows 10) becomes populated with a bunch of temporary file locations. These locations don't seem to me to be any location that I or a regular user would want to save a file to, except for extremely rare situations. Make EG, Windows, omit files locations in %USERPROFILE%\AppData when populating the Recent Locations section of the save as window. Or make an option for this feature to be enabled-disabled. Thanks

tomrvincent · ‎01-03-2019

Right now, if you show the properties of a dataset, only a few values (file name, created date, etc.) can be selected and copied. I think all fields in all tabs should be able to be copied, such as Rows and Columns on the Advanced tab, all fields on the Summary tab. This rule should be applied to all text windows.

ricardo_roberto · ‎07-01-2015

I suggest creating parameter to suppress columns with null values in the objects of the types Table and Table Crusade. This figure shows that the columns with null values (columns 1,2 and 3) take up space and confuse the report user. Thanks.

Allan_dk · ‎09-24-2014

When I have multiple sections in my report the user has to select the department on every section. They sometimes forget this and spend time looking at section two that contains information from another department. I can't always use linking between sections. Fx. when first section contains a filter on year and the second section shows data from all years. Therefore I would like to have the opportunity to make af filter prompt on reportlevel.

PhilC · ‎12-19-2019

Please change the behavior where Enterprise Guide interprets events in the SAS log as errors that are not ERRORs in the SAS log. "ERRORs in the SAS log" being an instance when SAS generates a log statement prefixed with the string "ERROR:". Example of this behavior. The format "gobble_dee_guk" is not defined for the purpose of this example. /*options FMTERR;*/ options noFMTERR; data _Null_; x= put (y,gobble_dee_guk.); stop; run; Without FMTERR: 29 options NoFMTERR; 30 31 data _Null_; 32 x= put (y,gobble_dee_guk.); _______________ 484 NOTE 484-185: Format GOBBLE_DEE_GUK was not found or could not be loaded. 33 stop; 34 run; NOTE: Variable y is uninitialized. NOTE: DATA statement used (Total process time): real time 1.11 seconds cpu time 0.03 seconds With FMTERR: 29 options FMTERR; 30 31 data _Null_; 32 x= put (y,gobble_dee_guk.); _______________ 48 ERROR 48-59: The format GOBBLE_DEE_GUK was not found or could not be loaded. 33 stop; 34 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 1.01 seconds cpu time 0.04 seconds If this program is run in Enterprise Guide, with the format not defined, and with option NOFMTERR set, then Enterprise Guide still interprets the SAS log as having an error, despite the absence of an "ERROR" statement in the log. Two problems this can cause: 1. This can result in submitted code being interrupted against the wishes of the programmer. 2. This is difficult to see or find this error in a log unless you have specific knowledge of this exception, since in the SAS log the item that clues the programmer as to what is causing the error is a "Note". See this link, I have a more editorial rant here if you're interested: EG8, options NOFMTERR, and submission status error

SASware Ballot becomes SAS Product Suggestions

Variable data text box

Help doc for sas functions if we add ? before any function

SAS Enterprise Guide 'Save As Type' (version) so users can get the good stuff sooner

Displaying Missing values at bottom of PROC FREQ output

Query Builder where used

Create (yet more) date and datetime formats. Hadoop requires "yyyy-mm-dd hh:mm:ss.ffffff"

Embeding SAS VA reports in iframe

SAS Enterprise Guide 8.2 - Revert back to original navigation method with primary workspaces

Z/OS SMS Compression with Zedc

Allow user to change code editor font in SAS Studio

Autogenerate a reports information flow so SAS VA end users understand report interactions

Enterprise Guide: Syntax highlighting of macro variable references in editor.

Page break in RTF

Add navigational tool to return to the beginning of a stack container

Make SAS indexes a bit smarter

EG: Save as, Recent Locations, Windows, AppData

Allow Text in Properties Windows to be Copied

Suppress columns with null values

Prompt on reportlevel

Change behaviors where EG recognizes a SAS log "notes" as "errors"

Extend text input capacity

Mouse click on an image in SAS Visual Analytics Modern Viewer (HTML5) ...

Possible translation error in Odds Ratio Estimates table

SAS VA search to find all queries submitted by a particular user and/o...

show a single data value

Add Autosave feature in SAS Visual Analytics

report definition auto archiving

SAS VA section interactions should act independently