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'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 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