topic Re: Issue with Partitioning Data in SAS Viya / Build Models in SAS Visual Analytics

Issue with Partitioning Data in SAS Viya / Build Models

wateas — Thu, 14 Nov 2024 17:28:28 GMT

I'm working in SAS Visual Analytics version 4.0. I would like to partition data in Build Models, but the corresponding menu in project settings is grayed out (see screenshot below).

Additionally, I would like to partition data in a specific way using my blocking variable "block". Based on the options shown above, there does not appear to be a way to do this. However, it does seem that the "Explore and Visualize" module has this capability, however, my blocking variable is not listed as an option for some reason (see screenshot below). Available are a number of categorical variables, and for some reason a single continuous variable. Note that the variable "Block" is visible in the data pane as a categorical variable with 4 levels.

Ideally, my data partitions would set training, validation, and test partitions to 50, 25, and 25%, respectively, using any of blocks 1, 2, 3, of 4.

Thanks for reading!

Re: Issue with Partitioning Data in SAS Viya / Build Models

Madelyn_SAS — Wed, 20 Nov 2024 22:05:23 GMT

If, instead of selecting New data item > Partition, you right-click on the Block data item, do you see a New partition option at the bottom of the context menu?

Re: Issue with Partitioning Data in SAS Viya / Build Models

wateas — Fri, 22 Nov 2024 19:06:07 GMT

Thanks for your response. Regarding your suggest to address the issue in the "Explore and Visualize" module, if I select "new partition" after right-clicking Block I get an error: "Cannot set this item as a partition because it is already in use by a partitionable analytic". So apparently some data item in my project is interfering. Regardless, it's good to know that I have an option to do this in the Explore and Visualize Module.

What about the "Build Pipelines" module?

From the partition data menu in project settings:
"Note: These settings are active only when a partition variable is not set within the data. Using a data source with a pre-defined partition variable or manually selecting a partition variable will override these settings."

How might I go about establishing a pre-defined partition variable?

Re: Issue with Partitioning Data in SAS Viya / Build Models

Madelyn_SAS — Fri, 22 Nov 2024 19:08:22 GMT

This message "Cannot set this item as a partition because it is already in use by a partitionable analytic" means that your Block data item is already assigned to a role in your object. You cannot use it in both the partition and as itself assigned to a role.

As far as doing this in Model Studio, this is the Visual Analytics (Explore & Visualize) community, so there will be varying levels of expertise on that product here. If you are unable to do this in Visual Analytics, I'd suggest opening a case with SAS Technical Support so that the team that supports Model Studio can assist.

https://support.sas.com/en/technical-support.html

Re: Issue with Partitioning Data in SAS Viya / Build Models

wateas — Fri, 22 Nov 2024 19:24:57 GMT

Regarding this issue in "Build Models", I see now that variables can be set to have a role of "partition", but that option appears to disappear after the pipeline has been run.