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