Question   How can I pass data from an Open Source Code node to next node in SAS Model Studio? Answer Using the “Use output data in child nodes” property available in SAS Visual Data Mining and Machine Learning 8.5 or later.   When this property is selected, user can write code in Python or R and should make the output data available in the dm_scoreddf data frame (if “Generate data frame” property is selected) or the node_scored.csv file. While executing, the node saves this output data and uses it as input in subsequent child node(s). Even though data can be passed through the Open Source Code node with this new property, capabilities such as download score code, download score API, register models, publish models or score holdout data will not be enabled for open source models as there is no underlying SAS score code for them.   An example of passing data created in Open Source Code node in Data Mining Preprocessing lane to subsequent modeling node (Forest and Gradient Boosting) can be found on GitHub at sas-viya-dmml-pipelines project. Example on GitHub   ... View more

Question   Is it possible to create indicator variables (for each input) for missing values without actually imputing in Model Studio? Answer Yes, add Imputation node to the pipeline, change the following properties and run the node.  Under Class Inputs, change Default method to none Under Interval Inputs, change Default method to none Under Indicators, (1) select Unique indicators check-box, (2) set Indicator subject to Missing variables and (3) set Indicator role to Input. You will see that there is a new variable (with M_ prefix) for every input that has a missing value in the training data. This new variable takes 0 or 1 values to indicate missingness (0=not missing, 1=missing).   ... View more

Question   Can the R ggplot package be used in the Open Source Code node for visualization purposes? Answer Yes, you can use the Open Source Code node in Model Studio to visualize plots using ggplot2 package in R software. Other Python or R visualization packages can also be used. The plots need to be saved as image files with rpt_ prefix and .png, .jpeg or .gif file extension. They will be displayed in the Results after the successful execution of the Open Source Code node.   Multiple visualizations using ggplot2 and rpart.plot packages are shown in this GitHub example.   Example on GitHub     Note that the above example requires pre-installation of rpart, rpart.plot and ggplot2 packages in R software on the Compute Server.   A special thanks to @MelodieRush for sharing similar example using SAS Enterprise Miner that led to this work. ... View more

Question For an existing project, would it be possible to: Reload the input table with additional records? Reload the input table with additional variables? Load the input table with different name? Change the way data is partitioned after any pipeline is executed? Answer The answer to all the above four questions is YES!   To change the data source or data partition for an existing project: Open the existing Project and go to the Data tab. Click on the “Data sources” icon   on the left. Click on “Replace data source” icon   on the top left – this gives you the capability to select a new data source; whether it is table with additional records, table with additional variables or table with a new name. Additionally, if you want change how the data is partitioned, follow the above steps and select the same or a new table. Then go to the “Partition Data” tab in Project settings (Top right icon  to modify accordingly.   Note that the target variable role in a Model Studio project cannot be modified after executing any node or pipeline in it. ... View more