Hi experts:   I have SAS Viya 3.5 and I need to export a table to parquet. Using CAS, I'm able to export the table to uncompressed Parquet files. However, we need these Parquet files to be compressed using SNAPPY. This is my current script: proc cas; * Load table to CAS; index / table={caslib="data" name="scored_202302.sas7bdat" singlepass=true} casout={caslib="data" name="scored_202302" blockSize=536870912 compress=true replication=0}; run; * Export as .parquet; table.save / table={caslib="data" name="scored_202302"} caslib="parquet" name="scored_202302.parquet" replace=true exportOptions={fileType='parquet'}; run; quit; Is there a way to generate achieve a parquet with SNAPPY compression?   Best regards, Javier ... View more

Hi experts:   I have a published model in CAS in SAS Model Manager. I need a "programmatically" way to access the features of the model in order to do some data preparation and reports in SAS Studio.   I know my models are published in this table, but I don't see any metadata about the features of the model.   I need to access this features from a published model in CAS (not MAS): Thank you in advance. ... View more

Hi experts: I've added a simple python model (no pickle) in SAS Model Manager following this example in the docs: https://documentation.sas.com/doc/en/mdlmgrcdc/15.4/mdlmgrqs/p1qjiqn6mcrdk6n1c4egttfhjrhd.htm#p03o5zinmhvnzqn1d6bqwr0xm93z   After generating the DS2 Code, I managed to publish the Python model in MAS (Score code type was set to "DS2 Package" by default), however, I had to change the Score code type to "DS2 embedded process" in order to deploy to CAS ("DS2 Package/DS2 multi-type" didn't work).   Unfortunately, when I try to test the publishing model in Scoring tab, in both cases I've got an unexpected output (MAS) or an error (CAS):     This is the log I've got in MAS: This is the log I've got in CAS:   Any hints? PD: I don't know if it helps, but when running through DS2 code in SAS Studio, I see a table is generated but no error in the log, though no data scored.   Thank you in advance. Best regards, Javier ... View more

Hi experts:   I'm writing custom tasks in SAS Studio and I would like to select a year (for example 2021) and show a list of selected checkboxes (all months from Jan to Dec). Since they are checkboxes also be able to select specific months. It's something similar to this image:   I've tried the to follow this example (dependency) but the I don't know whichs items can I use as the example. <Metadata> <Options> <Option name="cbxValue" inputType="checkbox" >Specify value</Option> <Option name="txtValue" inputType="inputtext">Enter a value</Option> </Options> </Metadata> <UI> <OptionItem option="cbxValue"/> <OptionItem option="txtValue"/> </UI> <OptionDependencies> <OptionDependency> <TriggerOption option="cbxValue"/> <TriggerValue value="true"> <ShowTarget option="txtValue"/> </TriggerValue> </OptionDependency> </OptionDependencies> Any reference or example?   Best regards, Javier ... View more

Hi: I have Viya 3.5. I managed to create a Job using the SAS Rest API. Now I need to move these Jobs to the SAS Environment Manager  Scheduling tab, but I haven't been able to find an action for this task.   It would be perfect to schedule from an API Rest call or command line? Otherwise, is there a way just to display Jobs in SAS Environment Manager (without scheduling)? Thank you in advance.   Best regards, Javier ... View more

Hi experts: We have SAS Viya 3.5 and need to deploy projects following DevOps practices for ML. We have a folder structure with .sas scripts that do the following tasks: Data Validation Feature Engineering: for now is pure CAS tasks, but in the future it will call a databricks data pipeline Model Scoring: it call a SAS Model Manager's published model Reporting: table for reporting in Visual Analytics Other steps (email/teams notification, etc.): call outook or teams API I need to schedule these steps.   I learnt how to execute scripts from command line and through APIs (from MAS in SAS Model Manager and SAS Intelligent Decision), but I need a way to orchestrate these .sas files in order. I see that in SAS 9 we have SAS Management Console, jobs dependencies and flow scheduling. Is there a way to do the same in SAS Viya through SAS Workflow Manager and schedule the whole workflow? Or should I use other tools like Airflow?   The only way I see is to create a main .sas script that includes other scripts and schedule it throught jobs in Environment Manager, but I would like to deacople the steps.   Sorry if the question is basic and general. I am open to all opinions.   Best regards, Javier ... View more

Hello experts: I have an on-premise deployment of SAS Viya 3.5 and Python 3.6 with sasctl-1.9.0. I registered 2 Python models with sasctl in the following Python Script: Then I tried to run some tests in SAS Model Manager, first of all, I've got an error (with no message nor log) but it was solved here (I had to manually change DS2 multi-type to DS2 Package). Now I got a log in the Results column. However, there's still an error for each model: This is an screenshoot of the error. The full log is attached.   I hope you can help me. Thank you in advance!! ... View more