partitioning data by a nominal variable

[DocMartin]

The partition mode in EM lets one split up a data set into training, validation, and test data sets base on random sampling. However, I want to partition my data by the values in a variable I call datset: 'D', 'V', 'T'. How can I achieve this using EM? Thanks! Andrew

[WendyCzika · Accepted solution]

You can do it with a SAS Code node with the following code:

data &EM_EXPORT_TRAIN &EM_EXPORT_VALIDATE &EM_EXPORT_TEST;
   set /* your data */;
   if datset='D' then output &em_export_train;
   else if datset='V' then output &em_export_validate;
   else if datset='T' then output &em_export_test;
   drop datset;
run;