Association analysis (proc assoc and proc rulegen)

[bob2012]

HI all,

I'm looking for help please.

I'm working with transactional data and looking for a way to find associations within transactions that will generate rules to assist our buying team, it's market basket analysis. The problem is I have SAS base and not SAS Miner, however I do have Enterprise guide 4 but at present not configured!

I gather from a little bit of research proc assoc and proc rulegen were procedures that allowed you to generate exactly what I'm after, e.g. If a customer buys shoes, then 10% of the time he also buys socks. A grocery chain may find that 80% of all shoppers are apt to buy a jar of salsa when they also purchase a bag of tortilla chips. When "do-it-yourselfers" buy latex paint they, also buy rollers 85% of the time. Forty percent of investors holding an equity index fund will have a growth fund in their portfolio.

Does anyone know what happened to these functions and why I can't use them anymore and if there's another workaround please?

Thanks and any help is much appreciated!

Zubair

[Reeza]

They both exist but are under Enterprise Miner License. 

Not familiar besides workarounds that involve other application solutions. Good Luck.

[bob2012]

Thanks Reeza!

Zubair

[karendean]

Reeza I am new to SAS and am lost.  I need to use PROC ASSOC and cannot figure out how to do it.  I have SAS/STAT.  Could you please help get me started?

THANK YOU

[gergely_batho]

As stated above, you need Enterpise Miner license to use PROC ASSOC. SAS/STAT is a dif

[Reeza]

There's a macro that does Market Basket Analysis using Base SAS - google for it on lexjansen.com.

Good Luck!