We’re smarter together. Learn from this collection of community knowledge and add your expertise.

Tip: Importing SAS® Rapid Predictive Modeler Projects into Enterprise Miner™

by SAS Employee RalphAbbey on ‎06-16-2014 02:42 PM - edited on ‎10-06-2015 01:52 PM by Community Manager (1,838 Views)

Intro:

Have you ever used SAS Rapid Predictive Modeler (RPM), but wanted to take it a step further? Have you liked what RPM has done for you, but now you want to get a behind-the-scenes look? You can! In this tip we detail how to use RPM as a starting point, but then import the project into Enterprise Miner for further analysis.

 

For a video demonstration of RPM check out this great youtube video: SAS® Rapid Predictive Modeler – A Brief Product Demonstration.

 

For a longer video tutorial of RPM including importing RPM projects into Enterprise Miner you can also view the extremely informative series:


Note: The following pictures may vary slightly by product version.

 

Accessing RPM:

You can access RPM either through SAS Enterprise Guide or the SAS Add-In for Microsoft Office. In Enterprise Guide you can find RPM by clicking the Tasks tab, then clicking Data Mining and finally selecting Rapid Predictive Modeler.

 

EG_open_rpm.png

 

If you wish to use the SAS Add-In for Microsoft Office, then you will access RPM through Microsoft Excel. The picture below shows accessing RPM from Excel 2013, but may differ based off of your Microsoft Office version.

 

AMO_open_rpm.png

 

Example:

In this example we are using the SASHELP.BASEBALL data set. Each observation is a baseball player. The variables are various career statistics and performance statistics for the year 1986, and the target is the salary of the player in the year 1987. The RPM window, whether opened from Enterprise Guide or Excel, will look like the picture below.

 

rpm_data.png

 

In this example we set the variable Name, which describes the player name, as an ID variable. We set Salary as the Dependent variable and we Exclude logSalary.

In RPM there are three different Modeling methods: Basic, Intermediate, and Advanced. Generally speaking, the three methods offer a choice between speed and model complexity. We explore the three different methods in some detail in a later Tip of the Week.

 

rpm_model.png

 

Once you have set your data properties and your modeling method you are ready to run RPM. In order to import your RPM project into Enterprise Miner, you first need to look at your RPM Options.

 

rpm_saveto_em.png

 

In the RPM options you have the choice to save the Enterprise Miner project data. You will want to have this box checked. You should carefully note the directory location under “SAS application server folder.” In this example my folder location is C:\Users\raabbe\Documents\My SAS Files\9.4. This is the location at which RPM creates your Enterprise Miner project. The project will be in a folder with the name specified in “Project name.” In our example the project name is RPM_to_EM.

 

Once you have run the RPM, the project will be created at this specified location. Let us look at Enterprise Miner now and see how to import this project.

 

Once you open Enterprise Miner, select “Open Project…” This will open a window in which you can browse to find the desired project to open. In our example, we need to browse to the location specified by RPM as the “SAS application server folder” which for me is C:\Users\raabbe\Documents\My SAS Files\9.4.

 

open_1.png

 

Here you see the folder RPM_to_EM, which is the project name we specified in RPM. You can see that this is located in the directory we expected. In order to open the project you should double click the RPM_to_EM folder.

 

open_2.png

 

Now you should select “project.emp” – this is the Enterprise Miner project file that you need to open. Once you have selected “project.emp” click the “Open” button. Your project should now open in Enterprise Miner!

 

RPM_in_EM.png

 

Conclusion:

We have examined how to start a Rapid Predictive Modeler project, and then import the project into Enterprise Miner.

 

Keep on the lookout for an upcoming tip that details the differences between the Basic, Intermediate, and Advanced methods, including sample flows, for the Rapid Predictive Modeler!

 

Happy Modeling!

Comments
by Occasional Contributor Murali11
on ‎07-21-2016 10:23 AM

Ralph, a very good article on tip for importing Rapid Modeler tasks to Enterprise Miner, especially for newbies like me. Great work.

Contributors
Your turn
Sign In!

Want to write an article? Sign in with your profile.