Hello,   The tests have been done on VIYA LTS 2023.03 and VIYA LTS 2024.09   I have tried to add a new index to a promoted table which has already other indexes (the reason why a new index has  to be added at a later moment rather than from the beginning is because new requirements and also the table is quite large and I try to avoid delete it and recreate it)   For the tests  I have used the table sashelp.cars which has been added to casuser and promoted. The first index has been added to variable "make" and a new table has been created and promoted. table.columnInfo has been used to check if the index has been applied  (please see code below).   proc cas; table.index / table={caslib='casuser',name="cars"}, casOut={name="cars_idx2", caslib='casuser',indexVars={"make"},promote=True}; table.columnInfo /table={name="cars_idx2",caslib="casuser"}; quit;   Later I have tried to add a new index to variable "type" to the promoted table casuser.cars_idx2. (the code is below)   proc cas; table.index / table={caslib='casuser',name="cars_idx2"}, casOut={name="cars_idx2", caslib='casuser', indexVars={"type"} ,replace=True}; table.columnInfo / table={name="cars_idx2", caslib="casuser"}; table.tableInfo / caslib="casuser", name="cars_idx2"; quit;   From table.columnInfo we can see that the index has been applied, but, looking at table.tableInfo results we can see that the scope of table cars_idx2 is no longer global but session scope.  The output of table.columnInfo and table.tableInfo is abovew. A similar behavior was presented in the article http://proc-x.com/2020/12/append-and-replace-records-in-a-cas-table/ where manipulating promoted cas table with data steps can leads to duplication of data. But in this scenario it seems that even a cas action can lead to duplicated data having local and global scope. I hoped that using "replace=True" would help.   Can I apply a new index to an existing promoted indexed table without having to delete and recreate that table?   Thank you for your comments.   Regards, smm662002 ... View more

Hello,   SAS VIYA LTS 2023.03   I have created a SAS Job to display the results of a qry using a proc report, but the styles used are never applied to the  HTML Output.  I have tried various combinations of styles with either html (or html5), but the output is different than presented in the documentation.   Thank you for your help.  The code is below. filename f_htm filesrvc parenturi="&SYS_JES_JOB_URI" name='_webout.htm'; ods html file=f_htm style=festival;    /*ods html5 file=f_htm style=highcontrast*/   proc report data=SAS_QREF.SALES nowindows split='~' spanrows style(report)={font_size=9pt } style(header)={just=center font_weight=bold font_size=9pt backgrondcolor=lightblue} style(column)={font_size=9pt protectspecialchars=on}; column COMPANY CONTACT ADDRESS; define COMPANY /order style(column)=[vjust=m just=l]; define CONTACT /display; define ADDRESS /display; run;   ods html close;           /*ods html5 close;*/   Regards, smm662002 ... View more

Hello,   SAS VIYA LTS 2023.03   I have created a SAS VIYA Job using a simple HTML form using two text box which are linked to a proc fedsql running in CAS. The input and output tables of the proc fedsql are in CAS. When proc fedsql is executed with hard coded values in the where statement the running time is about 15 seconds. When proc fedsql is executed with the values from the SAS Job (via the HTML form) in the where statement the running time is about 5 minutes.  The same values have been used via HTML form and hard coded and also the same input and output tables.   Can anyone please help with suggestions that can reduce the running time of the SAS Job?   Thank you, smm662002   ... View more

Hello,   Platform: SAS VIYA LTS 2023.03   I am trying to parse the data from a Data Grid using the macro %dcm_datagrid_interface in proc ds2.  The input table has about 50000 id's while the output table has only 353 id's (after sorting and transposing the output from ds2). While ds2 step is running the following error message is added to the log: "ERROR: Line 91: Datagrid _dg: End of file" The message above is repeated over 100 times.      Any help on the error above or the root cause of this error is much appreciated.    Thank you, smm662002    ... View more

Hello,   I am using SAS VIYA LTS 2023.03 and I have created  a SAS Job to upload and validate some xlsx files.  If I am only using the value "execute" parameter _action the job runs ok                 <input type="hidden" name="_action" value="execute"/> When I tried to add the value "wait", the animation "Please wait" is displayed, but the job is not running and returns the message  "Job was cancelled".                <input type="hidden" name="_action" value="execute,wait"/>   Thank you for your suggestions.   Regards, smm662002      ... View more

Hello,   SAS VIYA LTS 2023.03   We are running a SAS code, processing some DB2 tables and also saving the results to DB2. After last night run, in two of the fields we found that additional characters  have been added at the end of the string. The additional characters fills in the entire length of the string. In SAS Studio the additional charter looks like: which is repeated again and again creating something like: .  The same character copied to a text editor and using a different encoding looks like: �.  When I am scrolling in SAS Studio some the additional characters disappear but if I resize the table column  the additional characters reappears.    I have done the following tests but no improvements: - used VIYA in a different browser - reassigned the libname in a different Compute context   After checking with DB2 DBA no encoding changes occurs in the source or target DB2 tables.  Finally, the same table loaded directly from  DB2 using a different tool shows no additional characters for  the same fields.   What do you think?   Thank you.  smm662002         ... View more

Hello,   I am using SAS VIYA LTS 2023.03.   Having admin rights, I would like to create a list of all the SAS codes and SAS job definitions available on our SAS VIYA platform. Has anyone tried that before or maybe you can help with suggestions or starting points.   Thank you, smm662002 ... View more

Hello,   Would anyone know if page level security is available SAS Visual Analytics LTS 2023.03?   Thank you, smm662002 ... View more