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.?
It looks like you should use sampsio.assocs for the data= option on the PROC ASSOC statement instead of dmassoc.
Hope that helps,
Wendy
It looks like you should use sampsio.assocs for the data= option on the PROC ASSOC statement instead of dmassoc.
Hope that helps,
Wendy
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).
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.