Hi,   We are facing a situation maybe you can help us with. We are using SAS Visual Analytics 7.3 (maybe in a higher version is possible).   In SAS VA Designer we would like to sort a "List Table" table object but based on a column not shown in the "List Table". It's a requirement not to show that sorting variable.   We tried to build a "Custom Order" but we are facing limitation to less or equal 25 categories whereas we have many more categories so it does not seem we can address our requirement apparently with this approach.   Is there any way to sort the "List Table" based on a hidden column or anything we can do to fulfill our requirement?   Regards, ... View more

Hello!,   We have here a doubt with SAS/ACCESS Interface to ORACLE maybe someone over here could help us with. We have SAS 9.2.   When we run a explicit (something like "EXECUTE(statement)  by oracle;") INSERT statement we see in our SAS log a message like "ORACLE: XXX rows inserted/updated/deleted." We are using the SAS options:              OPTIONS SASTRACE=',,,d' SASTRACELOC=SASLOG NOSTSUFFIX;   Nevertheless, for the Oracle native MERGE (not the SAS one) in a EXECUTE(), with the same trace options, we don't find any trace in the SAS log on how many rows where merged. But we receive something like "YYY rows merged." in Oracle SQLPLUS or SQL DEVELOPER.   Do you how can we show number of merged rows (no matter updates/inserts) in the SAS LOG?   Thanks ... View more