Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

In Enterprise Miner, can I merge two datasets by a variable in the role of ID?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 11
Accepted Solution

In Enterprise Miner, can I merge two datasets by a variable in the role of ID?

I have two datasets with a commnon variable named Customer_ID. This ID variable's role was set to ID when it was initially imported into the EM as data source. Now I was trying to combine two two datasets through "Merge" node. In the property window, I set Merging type as "Match". But when I was trying to select the common varaible in the "By Ordering" menu, the Customer_ID was not there.


Accepted Solutions
Solution
‎10-02-2014 10:31 AM
SAS Super FREQ
Posts: 306

Re: In Enterprise Miner, can I merge two datasets by a variable in the role of ID?

Before opening the By Ordering dialog, right-click on the Merge node and select Edit Variables.  Then you can set the Merge Role for Customer_ID to be "By".  After clicking OK to close this dialog, you can now open the By Ordering dialog and you should see Customer_ID show up now (this step isn't necessary though).

Hope that helps!

View solution in original post


All Replies
Solution
‎10-02-2014 10:31 AM
SAS Super FREQ
Posts: 306

Re: In Enterprise Miner, can I merge two datasets by a variable in the role of ID?

Before opening the By Ordering dialog, right-click on the Merge node and select Edit Variables.  Then you can set the Merge Role for Customer_ID to be "By".  After clicking OK to close this dialog, you can now open the By Ordering dialog and you should see Customer_ID show up now (this step isn't necessary though).

Hope that helps!

Occasional Contributor
Posts: 11

Re: In Enterprise Miner, can I merge two datasets by a variable in the role of ID?

Posted in reply to WendyCzika

Thank you so much, Wendy. You saved me lots of time. I spent whole day yesterday but can't figure it out.

A further question - After running the Merge node, I right-clicked on the Merge node and select Edit Variables. All the variables listed there are coming from only one of two datasets. I thought I should see the variables from both datasets.

SAS Super FREQ
Posts: 306

Re: In Enterprise Miner, can I merge two datasets by a variable in the role of ID?

To see the variables in the merged data set, you can click on the button for Exported Data from the Properties panel when the Merge node is selected, then either Browse or click Properties to see the variables in the merged, exported train data.  Or connect the Merge node to another node, and in the new node you can do Edit Variables to see all the variables.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 2524 views
  • 3 likes
  • 2 in conversation