The ability to calculate product for an aggregated by group.  Requirement: Calculate compounded rate of return when you are given monthly rate of return Say,    I HAVE:   Client Financial Product Date Return Return +1 Customer A Product A Jan2016 2% $1.02   Product A Feb2016 3% $1.03   Product A Mar2016 1% $1.01   Product A Apr2016 7% $1.07   Product A May2016 -5% $0.95   Product A Jun2016 3% $1.03   Product A Jul2016 -0.50% $1.00   Product A Aug2016 3% $1.03   Product A Sep2016 2% $1.02   Product A Oct2016 5% $1.05   Product A Nov2016 1% $1.01   Product A Dec2016 -1% $0.99 Customer A Product B       .... ....       ..... .....       ....... .......       ......... .........       ......... .........        * I am using 12 months for ease of defining but the period can be more than 12 months too.   I WANT:   A slider with "Date" variable. When you move the slider and select a time period say May2016 to Oct2016 you get the output , which is product of Variable (Return+1) i.e 0.95*1.03*1.00*1.03*1.02 *1.05 = 1.079.   This way I can calculate compunded return for each product for same time period in this case May2016 to Oct2016.   This can be achieved in BASE SAS by creating a table htat comtains pre calculated returns for all the date combunations.  What do I men by date combinations: for 12 months- ther will be 66 distinct combinations say    Jan-Feb Jan march .. ..  jan-dec   feb-march   .. .. .. . . nov-dec      May to october -- as explained in this case is only 1 of those combinations.  Once you have the dataset, instead of using Slider, we can use two drop-down's for Start_Date and End_date variable. It is little cucumebrsome but the idea is to calculate product of observations selected/aggregated by group/sub-group.       ... View more

Along the lines of having better control of messages in the log, provide a way to disable warnings when a Hadoop string is 32k in length. If I run: proc sql; connect to hadoop ( &hadoop_connection.); select * from connection to hadoop ( describe extended TABLE ); I get the message: WARNING: The following columns could have a length in SAS of 32767. If so, SAS performance is impacted. See SAS/ACCESS documentation for details.  The columns read from Hive followed by the maximum length observed were:  col_name:450, data_type:639, comment:0   I should be able to query to Hadoop metadata without warnings.     ... View more

PX-Web is an API and interface for delivering statistic data. It is used by at least several statistical bureaus in Scandinavian and Europe. It has an powerful API which make it possibly to automatic download data. In R, there are an simple interface to PX-Web.   My suggestion is that SAS develop an interface to PX-Web API. Even better, an interface as an tool in Enterpris Guide and SAS Studio. I think it will benefit the users in Europe much.   I think it will be an easy work for a skilled programmer to do it. With my limitied skill, I have mangage build SAS code for the download, but still I have to redo the code for every task.   /Anders ... View more

BESSELK Function for Non-integer orders BesselK function is very important statistical function and used widely in insurance and banking sector. Most of the standard statistical packages such as Matlab, R and (even Excel) has got it as built in function. SAS has got JBessel and iBessel Functions but they are only available for positive orders which is not sufficient to calculate the BesselK function values for non-integer orders.SAS does not have this function and there is no way to approximate using iBessel or jBessel functions in SAS.   ... View more

Hello,   I wanted to share my experience with you regarding output generated by the Scorecard Node in SAS Enterprise Miner (EM), Version 14.1 in the Linux environment. I noticed that EM uses labels (as opposed to variable names) when creating the output from the Scorecard Node. If you have two characteristics, say Score_t0 (for Feb 2017) and Score_t1 (for Mar 2017) for a customer account but these characteristics have the same labels, say, Score then EM may bin these two characterstics using the Score label and you may not get the correct attributes. In other words, the attributes for these two different characteristics will be grouped together as one and you may get the same group for two levels of these characteristics. I should mention that the attibutes are correct when you view the Interactive Grouping Node window but the output from the Scorecard Node is not correct.   I had the same label for this variable, since I was extracting data in Base SAS, using the SQL pass through facility from the data warehouse. For coding purposes in Base SAS, we use variable names and not labels, and so it never occured to me that EM would use labels in the Scorecard Node output. To illustrate this issue, please see the partial output that is attached.   Based on my experience, I would suggest that SAS EM should use variable names (to be consistent with Base SAS) when creating outputs in SAS EM. If other users have also experienced this issue, can we make a recommendation to the SAS Institute to use variable names and not labels for output generated in SAS EM.   Thanks,   Nilotpal ... View more

Sometimes I want to interrogate data down in the murky depths of a large table (e.g. >100k rows). Unfortunately SAS EG only lets me see 10,000 rows. I'm not aware of an obvious option/setting to make this bigger. I'm forced to export the data into an external file before I can view all the data. This is an unnecessary click-fest. Especially when I am trying to interrogate multiple large tables (e.g. if i am debugging/sense-checking/quick-checking/verifying). I just want SAS to show my rows 10,001 to N as I scroll down to the bottom of the table.   Also, on a similar vein, I want to quickly copy-paste more than 10,000 rows of data from SAS EG to a spreadsheet/text editor. I don't want to go through the SAS-right-click-and-select-export-method-from-menu-just-cos-i-have-10000-plus-rows feature (because it is a click-fest). A quick Ctrl-c, Ctrl-v is a lot faster and convenient especially if the copy-paste is just a once-off, and I want to do many Ctrl-c, Ctrl-v on a few tables to do some quick checking.   Incidentally, when selecting data, ctrl-c should copy data and ctrl-shift-c should copy data with column headers in my opinion.   Also, when viewing a large table in SAS, click-holding the scroll bar conveniently tells us "Row X of N". Except, when N is a large number, it tells us "Row X of 800+" or "Row X of 1650+". That's rather uninformative. I'd like to know how big N is. Why don't we just permanently display N somewhere on a status bar in SAS EG. I am aware you can right-click the table, click [Properties], click [Advanced] and see the number of [Rows]. Except, for large N, the [Rows] displays [Unknown], which is also unhelpful and in addition, right-clicking is just another click-fest if you are doing quick row size checks for multiple tables. ... View more

As the "Query Bulder" task is programmed.   With the "Query Bulder" task, if one selects multiple datasets in a process flow then creates a Query Builder Task, then, not only is the Query Builder Task linked to all selected datasets, but the selected data sets are added to the list of tables of that task.    This is a very natural-feeling feature of the GUI. I'd like to see it used with other tasks that my use multiple datasets.  The "Append Table" task is one of these tasks that could have this behaviour.  I'm hoping this is a short, fast change that can be implemented easily. ... View more

I don't know exactly when this changed, but I once was able to use <shift><alt> to block-select text (i.e. with arrow keys or mouse clicks) then immediately use <Ctrl><C> to copy the text or <delete> to delete it.  Currently [version 7.13 HF3 (7.100.3.5438) (32-bit, PC)] the focus, after block-selecting, moves to the tool bar above the editor disabling any keyboard shortcut on the text that was recently selected.    One present solution whereby the user right-clicks on the selection to choose an action on the drop down menu, is present, but its not as good as it was when the shortcut keys could be used.  (please, thanks) ... View more

It would be great to be able to copy an existing Ordered List in Enterprise Guide. From time to time I need to duplicate an existing Ordered List but with some small changes (adding or removing a couple of programs). Being able to a copy an existing Ordered List would save some time. Currently, if I need to create a similar Ordered List to one that already exists I need to create a new one from scratch.  ... View more

Sometimes the SAS code interpreter assumes a typo, for example when I submit a tabels statement in Proc Freq, SAS gives a warning and runs a tables statement instead.   Many, if not most, programmers use one statement per line. Some programmers, including me, sometimes forget one or more semicolons, for example after a * comment.   I would like to get some help here. If my submitted code ends up in errors or warnings, can the code interpreter add missing semicolons at the end of a line and then try again?   ... View more

We have a crosstab where we show a measure per day on the right side of the table.       However, when exported to excel, the dates are show as the first column. Users need to then do a pivot table.   It woudl be great to preserve the format when exporting to Excel.   ... View more

I think it woudl be great if they added an option to the HPFOREST node to automatically generate and visualize a  'representative tree' from the many trees that are assembled under the hood. This would take way some of the black box nature of this technique and there already is reserach on how best to show your most representative tree:     http://onlinelibrary.wiley.com/doi/10.1002/sim.4492/abstract http://www-stat.wharton.upenn.edu/~edgeorge/Research_papers/forestCART.pdf ... View more

Hello,   This may be a hard one to do but in line with the current direction it would be good to see support for Presto. Alot of other vendors have added it in the past year.   Link: https://prestodb.io/ ... View more

Add identity column (surrogate key) functionality to Base and SPDE datasets, such as available in SQL Server.   If I have a 500M record SAS dataset, it would be great if I could efficiently retrieve the max value of the surrogate key (identity) column from the header of the table.   I can provide more details if needed. ... View more

I should be able, like in Explorer, to specify the values for min, middle and max for colors in a treemap in the Designer / Report. If I want to do this for now, I have to save the treemap in Explorer and import it in a report. But then, if I want to change something, like adding an interaction, it won't allow me to do it. ... View more

I'd like the Enhanced Editor of the next version of PC SAS to have a function to convert the spaces within a highlighted section of code to underscores.   It would take: my new variable and covert it to: my_new_variable   I'd suggest Ctrl + Shift + - as the shortcut. This is something that I would use numerous times per day. ... View more

It would be very helpful to be able to search SAS VA to find all queries submitted by a particular user and/or by keywords. ... View more

Purpose: to allow code in "text" nodes to be searched by OS search utilities which is now hidden in EGP files due to the compression of this information.   Change: Add options to the program's options and the file's options to instruct EG so that when a project is saved, EG saves certain nodes in an un-compressed XML file in the same destination folder as the usual EGP file that is created at save.  By text node, we mean either program nodes, "last code submitted" nodes, log nodes, and/or note nodes, etc. The program options would control default behavior of newly created files, where the file's options would override the default-behavior options for the specific file. I would not see this to be used in conjuction with EGP files saved with password encryption.   Motivation:  My working group has always used SAS Interactive and Batch and is accustomed to using the OS to perform text searches of their collections of SAS program files.  The decision to design EGP files as compressed files with a internal file structure makes these files non searchable in usual, conventional ways.  An idea like this can allow an OS to search EGP files as SAS files, if the user chooses.   Other ideals to implement in conjunction with this idea: store this XML file in the EGP file but not as a non-compressed file in the zip file structure. Program EG so that when it is called to open an "XML" like this, one that it created, then EG would instead open the accompanying sister EGP file, if it exists -- if it has same modified date. The XML schema could be simply implemented.  One XML tag for each node, with at least the process flow and node names stored. Or a more complicated schema -but- not too complicated. Or the file is just a text file, not involving XML.  But also stored in a away that would prevent these files from being inadvertantly ran like conventional SAS code files. Allow user to choose which type of text nodes are to be included in the text output XML file: e.g. program nodes, "last code submitted" nodes, log nodes, and/or note nodes, etc. ... View more

As in the classic look mouse clicking once on an image should link you directly to another section or report without having to click three times to get to the linked object. ... View more