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

Association Analysis - proc rulegen

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Association Analysis - proc rulegen

I am trying to run example code from SAS proc rulegen documentation:

proc dmdb batch data=sampsio.assocs out=dmassoc dmdbcat=catassoc; id customer; class product(desc); run; proc assoc data=dmassoc dmdbcat=catassoc out=datassoc(label='Output from Proc Assoc') items=5 support=20; cust customer; target product; run;  

First part works well, but second gives an error:

The data= dataset should not be DMDB encoded type

Does anyone know what the problem is? I use SAS Enterprise Guide 6.100, no EM - is it possible for me to use proc rulegen, proc assoc, etc.?


Accepted Solutions
Solution
‎11-26-2014 12:57 PM
SAS Super FREQ
Posts: 272

Re: Association Analysis - proc rulegen

It looks like you should use sampsio.assocs for the data= option on the PROC ASSOC statement instead of dmassoc.

Hope that helps,

Wendy

View solution in original post


All Replies
Solution
‎11-26-2014 12:57 PM
SAS Super FREQ
Posts: 272

Re: Association Analysis - proc rulegen

It looks like you should use sampsio.assocs for the data= option on the PROC ASSOC statement instead of dmassoc.

Hope that helps,

Wendy

New Contributor
Posts: 2

Re: Association Analysis - proc rulegen

Thank you WendyCzika, it helped. However, when using own data (not this from the example) they have to be sorted by customer (and proc dmdb step may be needed in order to create a catassoc catalog).

Super Contributor
Posts: 336

Re: Association Analysis - proc rulegen

Hi ajanie,

What are you trying to do? Score new data using Enterprise Guide?

If that is the case, add a Score node to your flow, run it, and borrow the optimized score code.

The reason you need the sorted by customer is that there is an id statement in your proc dmdb.

I hope it helps,

M

🔒 This topic is solved and locked.

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

Discussion stats
  • 3 replies
  • 977 views
  • 0 likes
  • 3 in conversation