turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- Analytics
- /
- Data Mining
- /
- Enterprise Miner PROC CORR SAS Code Node %EM_REPOR...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

04-07-2017 03:30 AM

Hi There. I am trying to create a SAS Code Node in Enterprise Miner, that will visually show me a correlation matrix. The SAS Code Node follows an Interactive Grouping node, so the correlation should be done on all the interval variables, some create by the Interactive Grouping Node.

When I open the "Results" after running the node, it gives me an error saying "Variable not found in data set". No variable is mentioned.

I am fairly new to Enterprise Miner, I might be missing something obvious.

The code I'm using in the SAS Code Node:

%EM_REGISTER(type=DATA, key=CORRPLOT);

proc corr data=&EM_IMPORT_DATA. out=&em_user_CORRPLOT. pearson plots=matrix;

var %EM_INTERVAL_INPUT;

run;

%EM_REPORT(key=CORRPLOT, viewtype=HISTOGRAM, X=_X_, Y=_Y_, FREQ=correlation, autodisplay=Y, block=Correlation, description=Correlation Plot);

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

04-07-2017 09:08 AM

If you do a proc print of the data set you are trying to plot, you can see the variables _X_, _Y_, and Correlation are not in the data set, so the %EM_REPORT call is failing.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

04-10-2017 04:23 AM

Thanks Wendy - the post I got this from uses _X_ and _Y_, it seems as though they are trying to plot all the variables against each other, which is correct.

Do you perhaps have any idea what I can use to call all the variables?