SAS Integration technology package enables users to build client/server infrastructure. However, in order for client to take the IOM Bridge for COM to use the CryptoAPI algorithms to communicate with the IOM server, we need to install tcpdcapi.dll on client with SAS/SECURE. It is required from SAS 9.4M8. In that case, how do we install the tcpdcapi.dll on client machine alternatively along with the SAS Integration technology? ... View more

We would like to know if it is possible to make the error when trying to log in more specific and indicate the reason why it was not possible. Sometimes the username and password are correct but the real reason for not being able to log in is that the account is locked in the active directory and this is not shown in the application message. Can the error messages be customized to be more specific? For example: Cannot log in because the user does not exist. Cannot login because the password is invalid. Cannot login because the account is locked in the active directory. Cannot login because your password has expired, or your password expires in x days.   ... View more

According to SAS Documentation, "An analysis variable is a numeric variable that is used to calculate a statistic for all the observations represented by a cell of the report." I would love to have some summary functions for character variables as well, such as coalesce or count. Example Use Case Given a dataset like this: Be able to create a report like this:   data toprint; input groupvar $ acrossvar $ charvar $ numvar; datalines; Group1 Across1 A 1 Group2 Across1 Q 4 Group1 Across2 T 1 Group2 Across2 F 7 ; run; /* The desired report is easily created for a numeric variable */ proc report data=toprint; column groupvar numvar,acrossvar; define groupvar / group; define acrossvar / " " across; define numvar / " " analysis sum; run; /* But for a character variable you can only get a "stairstep" output */ proc report data=toprint; column groupvar charvar,acrossvar; define groupvar / order; define acrossvar / " " across; define cahrvar / " " display; run; /* The desired functionality might look something like the following */ /** This code does not work **/ proc report data=toprint; column groupvar charvar,acrossvar; define groupvar / group; define acrossvar / " " across; define charvar / " " analysis coalesce; run;   In a pharmaceutical setting, groupvar might be usubjid, you might have parcat1 and param as across variables, and charvar might be avalc. This functionality would allow you to create a wide format listing of character data with very little work.   ... View more

We already use HPGLM node in our SAS Enterprise Miner (SAS E.M.) 15.1 to develop our price and fraud models. And they work on SAS E.M. But, to score them in our production environment, we use JAVA (our environments are FICO Blaze). Recently, we had problems in this exported code. We reach your Technical support team (track 7613643392) and they can't help us. Their answer was: SAS doesn't support this export (Java score code) in this Node (HPGLM). It doesn't sound good to me. Usually, if one node contains this option (the export option is there). Further, we have many models in HPGLM using this score exported to Java and they are working o.k. 93% of our models work with this option (only 2 fails on almost 30 models). And, We know how it should be corrected (we send all files through the Support track). It seems that it would be one simple change on the generated java code. The variable initialization. Just one row of code. For us, as customer, it seems that it would be simple to SAS to correct this code and make HPGLM node supportable by Java export code. And it would be great! As we have many models and many of them in HPGLM node, if it wouldn't be corrected (and with support for this node and this score export task) we will leave our SAS E.M. usage (for all of our Modeling tasks) to addopt other tool where we can use multivariate model and export to Java. ... View more

Two-way breadcrumbs are great because some users want to remove a selection but with a one-way breadcrumb, everything past that selection disappears. However, with two-way breadcrumbs, it's impossible to change the selections at times. An example:   A dropdown with Fall, Spring, and Summer options, where we selected Fall. We then select a college, and maybe gender.    I then remove college and gender and then want to go back and select Spring. I can't. I can only see Fall. I assume because the data is not for the fall so there is no way to go back and select Spring.    I can provide more context if needed.  ... View more

We've had multiple complaints and requests for breadcrumbs at the report filter level when we have multiple tabs in a report. It's difficult for users to remember what they selected because they can't always see their selections in drop-down controls or a prompt with a list control.  It tends to be inconvenient to create page filters and copy them to each tab because users have to reselect their options. ... View more

Due to cybersecurity restrictions, our SAS Site Administrators have enforced system options like SOURCE, SOURCE2 and MPRINT on every SAS session to make sure that every single line of submitted code is printed on the SAS Log. Options SOURCE and SOURCE2 pose no particular problem.  But a locked-in MPRINT option has the unwanted effect of multiplying the number of lines of Macro Code being printed on the Log, every time a Macro is invoked. Having a system option that displays the Macro Code only once (regardless of how many times the Macro is called in the program) would be very helpful to reduce the number of lines displayed on the Log. MPRINT is a debugging option that works well as it does. The new option could be named somewhat differently (maybe MLOG ?). ... View more

Please bring back the Narratives from the PSS (Power and Sample Size) application. I found this very useful for rapidly generating a sensible, accurate report.   According to SAS Technical Support, the PSS application was replaced by a set of tasks in SAS Studio 3.6, but does not include the Narratives (described near the bottom of this page:https://support.sas.com/documentation/cdl/en/statug/63962/HTML/default/viewer.htm#statug_clientpss_sect006.htm )   More discussion here: https://communities.sas.com/t5/Community-Suggestion-Box/Bring-back-the-Narratives-from-the-PSS-Power-and-Sample-Size/idc-p/831196  ... View more

A feature present in previous versions, before VA 8.3, the reference lines can't be customised anymore. We would like to customise the reference lines with colours and styles. In a report created with dark colours, the reference lines can't be seen as they are also black. That influences reports that can be created in the style and colour scheme of a particular brand. The reference line text should also allow to be customised, allowing to change font, colour and size. The line itself could be dotted, solid or other variations. The text also is over other text when more than one line is close to each other, so the direction of the text should be automated to not overlap or allow customisation to choose the direction of the text. Moreover, the reference lines could be part of the rules so you can change them all at once in all reports. Thank you. Example of how all this is not working currently: Example of Reference Lines with dark background and reference lines text that can't be moved or customised. ... View more

The FDA asked us to use a method other than Wald and strongly suggested that we use Miettinen-Nurminen 1985 (MN) for computing confidence limits (CL) at summary level. This method is becoming increasingly popular and is used by many pharmaceutical companies, including Merck, Abbvie, and Moderna (cf. simple Google search). SAS has provided a partial implementation of MN scoring through COMMONRISKDIFF(CL=score) where the within-stratum calculation follows MN 1985 but inverse-variance stratum weights are used at the summary level. This method comes from the 2013 Agresti book. Has this method ever been published in a peer-reviewed article? Has it ever been used in a clinical trial submission? Is this method popular, i.e., number of citations? The lack of visibility in the use of this "SCORE" method prevent the use of this algorithm in a submission to health authorities.   The current alternative is to use R. Indeed, two packages have been developed to calculate CL based on MN 1985 method: metalite.ae (Merck) and scoreci. SAS users have already written about this 4 years ago.  I am a biostatistical manager at Bristol Myers Squibb. This issue has risen to the VP level as we plan to adopt MN 1985 in all our submissions in all the therapeutic areas. Confidence limits play an important role because they influence key analyses such as futility analysis for the primary outcome. Will you provide this algorithm and if so, when? ... View more

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.  ... View more

Request to SAS: Please provide, in every SAS version, a tool to convert files/catalogs between 32 and 64 bit (without the need to buy a licence for a new 'SAS module'). This should not be a problem for experienced (SAS) programmer. Thanks. ... View more

Today a user asked how to show the top 2 values for each bygroup in a VA object on the VA community.   We don't seem to have a good way to do this in VA. It seems like it would be a logical feature to add a "Context" option on the rank definition on the Ranks pane to let you switch between the ByGroup and ForAll contexts, similar to the _ByGroup_ | _ForAll_ context we specify for aggregations in the expression editor.   For example, if we have this crosstab:   We could make a ranking on Model that would return the top two models for each Type category:     Currently I believe this can only be achieved with by precalculating the rank. ... View more

After building a bayesian model it would be great to have simple way to run counterfactual analysis. Perhaps a procedure where we could specify the model and a variable that we want to simulate different values for. The output could include the target variable values for the different input variable values and a sensitivity (tornado) diagram. ... View more

SAS studio is missing the Prompt feature from SAS Enterprise guide. The current work around is difficult and if we were to use SAS studio as a replacement for Enterprise Guide, we need this feature. ... View more

Hi, Two variables of the same name are used in a merge without being listed in the by statement is usually unintentionnal (usually done by mistake). As far I'm aware of, the only way to be informed about it is to display information messages in the log using options msglevel=i;. But That option is not in the default setting. The message is not really easy to notice (black color) and not listed in the interface         Other messages which are usually not that relevant popup on the way with this option. Would it be possible to have a global option called for example mergeoverwrite= (or any other relevant name) with WARN by default (as VARLENCHK=)?   data one; key=1; x=1; output; key=2; x=2; output; run; data two; key=1; x=5; output; key=2; x=6; output; run; *options mergeoverwrite=WARN; options msglevel=i; data demo; merge one two; by key; run;   ... View more

data a; b=3; output; b=.; output; run;   proc datasets nolist; modify a; ic create not null(b); ic create check(where=(b=3)); quit;   Currently both these ICs will display:   ERROR: Integrity constraint _CK0001_ was rejected because 1 observations failed the constraint.   Would be handy to have a sample of the errors, similar to the data step:   …was rejected because _n_=2 b=.   Currently after receiving the error you have to regenerate the data set (if you're in batch), then subset it based on the IC to find the failing observations.   (Forum software was complaining non-specifically about an HTML error, then about me spamming when I tried again, so have removed all formatting. An hour lockout seems excessive.) ... View more

In SAS Visual Analytics, similar like changing the position of report of page filters, it would be nice to be able to change the position of the pages. The pages are currently on the top of a report but then can be placed on the left, right or bottom. And even better be able to change the color, font, etc.. ... View more

The Ability to export in excel conditional highlighting from display rules of table ... View more