About smm662002

smm662002 · ‎04-22-2022

Hello, SAS VIYA 3.5 SAS Visual Analytics 8.5 I have tried to integrate the SAS job sample "Dynamic Prompts using CARS Data" in Visual Analytics using "Web content" but it returns the error: "Popups must be enabled". I mention that I added allow-popups to "IFrame Sandbox Attribute Value" property in SAS Environmental Manager, and also changed the popups settings in my browser (I have tried Chrome and Mozilla). Even after these changes the error was not solved. Can anyone advise if other configuration changes have to be made in SAS Environmental Manager? Thank you, smm662002

smm662002 · ‎04-04-2022

Hi, proc casutil; list tables incaslib="My CAS"; /* does this work? */ quit; works ok. The goal was to find if I can use nonstandard caslibs in data steps. Otherwise I can always use fedsql if needed. Thank you for your help. Regards, smm662002

smm662002 · ‎04-04-2022

Hi, The CASLIB was defined by the SAS admin so not sure exactly how they have done it. The log verify that the value of the VALIDVARNAME option is 'ANY' but this is on the Compute Server while the code would run on CAS server. Thank you, smm662002

smm662002 · ‎04-04-2022

Hi, Thank you for your reply. The caslib shows up in the list when using calib _all_ list but when trying to use data "My CAS"n.table; ... run; it returns an error saying that the Libref exceeds 8 characters (because the libname I am using has more than 8 characters) Regards, smm662002

smm662002 · ‎04-04-2022

Hello, SAS VIYA: 3.5 SAS Studio: 5.2 Has anyone managed to write to a non standard caslib in a data step? I have tried the following but it returns error. data "My CAS".table; set casuser.table1; run; I am aware that it is possible to do it in a proc fedsql. proc fedsql sessref=test; create table "My CAS".table as select * from casuser.table1; quit; Thank you, smm662002

smm662002 · ‎03-09-2022

Hello, SAS VIYA : 3.5 SAS Visual Analytics : 8.5 Can anyone advise if is possible to enter multiple values separated by a delimiter (comma, or other) in a text box, to filter a list object? For example: The List object has the values: 00000a, 0000ab, 00000c, 00100c, 12345d I have linked the text object to a parameter and created an advanced filter using "contains" so that if in the text box I enter "0a" the list box will display 0000a and 0000ab. What I would like to do is to enter: - "0a","0c" in the text box and the list object to display 00000a, 0000ab, 00000c, 00100c, or - "100c", "5d" in the text box and the list object to display 00100c, 12345d I have tried to allow multiple values in the text parameter so that I can use "in" operator but I couldn't assigned it to the text box parameter role. Also I'm wondering if we can use wildcards in the text box? Thank you, smm662002

smm662002 · ‎02-25-2022

Hello, SAS VIYA 3.5 SAS Visual Analytics 8.5 Can anyone advise how can we change the text style for "lattice columns" for a vertical bar chart in SAS Visual Analytics 8.5? In Options menu I was only able to find options for X Axis Options (please see below). Thank you for your help. Regards, smm662002

smm662002 · ‎01-18-2022

Hi, Thank you so much for your answer. Spot on. Initially I tried with "string" type for table2 but I had a similar error hence I decided to change to "CASOUTTABLE". Would you have any additional documentation describing when to use the types "CASOUTTABLE" | "CASTABLE" | "CASVAR" | "PARAMLIST" ? Also I had the impression that send_response is always required but your answer is proving that I misunderstood it. Thank you, smm662002

smm662002 · ‎01-18-2022

Hello, I am using SAS VIYA 3.5. Has anybody tried to define an in-memory table in the "definition" parameter of "builtins.defineActionSet"? (I am aware that the table can be created when we call the new custom CAS action using "savereresult" statement) For example in the following code I have tried to save the details of the table TBL in table CASUSER.TBL_RES directly from the definition of the new action set. I think that "send_response" highlighted in orange is not right. The error code I receive is below the code. Thank you for your suggestions. Regards, smm662002 proc cas; builtins.defineActionSet / name ="myActSet2" actions= { { name="lsttblDet" desc="Display Table Details" parms={ {name="caslib" type="string" required=TRUE isCaslib=TRUE} {name="table" type="string" required=TRUE} {name="caslib2" type="string" required=TRUE isCaslib=TRUE} {name="table2" type="CASOUTTABLE" required=TRUE} } definition=" table.tableDetails result=a /caslib=caslib table=table; temp=findtable(a); saveresult temp caslib=caslib2 casout=table2; send_response(caslib2.table2); " } }; quit; proc cas; myActSet2.lsttblDet / caslib=casuser table=TBL caslib2=casuser table2=TBL_a; quit; NOTE: Active Session now DEMO. WARNING: Variable 'casuser' is uninitialized. It has been set to missing. WARNING: Variable 'cars' is uninitialized. It has been set to missing. WARNING: Variable 'cars_a2' is uninitialized. It has been set to missing. ERROR: Cannot convert parameter 'caslib' from double to string. ERROR: The action stopped due to errors.

smm662002 · ‎12-13-2021

Hi, Thank you for your answer. The data presented in the post is just an extract from a larger table having over 100 columns and a few million records. This data is calculated data rather than raw data. The data can have further transformations, but the question was if the desired chart can be created in SAS Visual Analytics using the data as it is now. Thank you, smm662002

smm662002 · ‎12-13-2021

Hello, SAS VIYA: 3.5 SAS Visual Analytics: 8.5 Having a table with the following structure (table is loaded in CAS) would it be possible to create a bar chart like in the example below without having to create new a new table (in SAS Studio) to summarise the data? I'm wondering if it is possible to manipulate the data only in SAS Visual Analytics. V1 V2 V3 0 0 0 1 0 0 1 0 0 1 1 1 1 1 1 0 1 0 1 1 0 1 1 1 1 0 1 0 1 Thank you, smm662002

smm662002 · ‎08-11-2021

Hi Eyal, Thank you for your reply. CAS action table.tableDetails provides two useful columns "Data size" and "Variable Data size". Would you know if table size is the sum of "Data size" and "Variable Data size"? Thank you, Madalin

smm662002 · ‎08-11-2021

Hello, Can anybody advise which is the most accurate method to get the size of a table in CAS? Thank you, Madalin

smm662002 · ‎08-12-2016

Hello, Thank you for your answer. Unfortunately I can not send the full log file. The proc fcmp used is the one presented in the link below: http://blogs.sas.com/content/sasdummy/2011/05/09/calculating-the-number-of-working-days-between-two-dates/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+ASasBlogForTheRestOfUs+%28The+SAS+Dummy%29 I have run the proc fcmp on GRID because the function is later in the process. If I don't run the proc fcmp on grid the code would return an error. Would it be possible to explain more on your sugestion to not run thr fcmp on GRID but just provide the function to the othe GRID processes? Thank you, Madalin

smm662002 · ‎08-12-2016

Hello, When running proc fcmp on Unix grid I receive the below warning: "The filename "work.funcs.test" has too many levels, only the first 2 levels will be used" work.funcs.test is used in outlib and in options cmplib The warning is not produced if the same proc fcmp is run on Windows server. The results creted by the function are right and not impacted by this warning. The code is running in SAS 9.2 Base. Would anybody knows what changes I need to stop receving this warning. Thank you, Madalin

Online Status	Offline
Date Last Visited	‎08-11-2025 07:25 AM

proc ds2 error

Rule to restrict reports edit for custom user group

Add index to a CAS table which is already indexed

Why style not applied to SAS Job HTML output?

Re: SAS VIYA Job Schedule Issue

SAS VIYA Job Schedule Issue

Re: Optimising SAS VIYA Jobs

Optimising SAS VIYA Jobs

Proc DS2 error when processing Data Grid

SAS JES _action name=wait issues

Re: Pie Chart Legend Issue

Re: Create geo-line geography roles

Rule to restrict reports edit for custom user group

Re: CAS action table.tableInfo - create date detail issues

Re: SAS VIYA 3.5 Environment Manager Monitor Job inconsistent Status r...

Re: load dataset from client to CAS

Re: Writing to a non standard caslib in data step

SAS VIYA Job with Web content returns error

Re: Writing to a non standard caslib in data step

Re: Writing to a non standard caslib in data step

Re: Writing to a non standard caslib in data step

Writing to a non standard caslib in data step

Filter list object using multiple text box entries

Change lattice columns text style for bar chart

Re: Create in-memory table using user-defined action in SAS VIYA CASL

Create in-memory table using user-defined action in SAS VIYA CASL

Re: Bar chart for binary data

Bar chart for binary data

Re: How to get the size of a table in CAS?

How to get the size of a table in CAS?

Re: Proc fcmp warning when run on Unix Grid

Proc fcmp warning when run on Unix Grid