Hi, I have a dataset with an 'ID' column that isn't quite unique (there's one for each year). I need to find the unique values, split the dataset b/w train/validate/test and then bring in all the associated columns back in for all 3. I've tried two methods but have gotten stuck with both: 1. Do the majority of the work in a SAS code node - I have done this but I don't know how to export these 3 sets out to be able to use it with the rest of the model. Everything is 'stuck' in the workspace. 2. Create a data source of just the unique ID's then use a data partition node for the 3 dataset. Then use a merge node with the original complete dataset and the data partition node. This only merges the training set, however, at least from what I can tell. There's probably a much more intuitive option 3 I'm not thinking of. Thanks!
... View more