BookmarkSubscribeRSS Feed
eyespike1
Calcite | Level 5

Hi, I am currently using RPM in Excel to create a basic model. I am then using Enterprise Miner 12.3 to tweak the model and use scoring and code nodes.

When you open the RPM Diagram in Enterprise Miner it has a temporary dataset WORK._EXCEL_. Since the dataset is temporary I have been replacing the node with a file import node.

When I import the new file (which is the same as the temp file) using the file import node, existing roles and levels are lost. Is it possible to copy them so I don't have to make the changes again?

Hope this makes sense.

Thanks!

Seth

Variables.PNG

2 REPLIES 2
M_Maldonado
Barite | Level 11

Hi Seth,

There might be a few ways to do this. Have you tried using the metadata node to save the roles and levels of your variables?

I hope it helps!
Miguel

eyespike1
Calcite | Level 5

Hi Miguel,

I have added a Metadata node and can now see the output variables with their roles and levels. I'm not sure how to "save" the roles and levels to be applied to a newly added dataset. Do I export path as a SAS program then add that as a node?

Thanks!

Seth

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1448 views
  • 0 likes
  • 2 in conversation