Association Analysis and Market Basket Analysis

[frupaul]

Hi All,

Is there a macro for doing Association Analysis or Market Basket analysis on Base SAS or SAS EG?

Thanks,

Paul

[Reeza]

Yes, there is, via Google

http://www2.sas.com/proceedings/sugi28/223-28.pdf

[frupaul]

Well the pdf document opens but the site that contains the macro won’t open in the UK by Any internet provider. I doubt that is a legit site.

Can you upload copy the macro onto a pdf and upload it on here please?

[Reeza]

If Lexjanen.com is back up try that site instead. I know there’s a copy there for sure, still in PDF unfortunately. 

[sld · Accepted solution]

Try this link

http://clarioanalytics.github.io/marketbasket/

Things change in 14 years 🙂

[rahul_wishard]

There is an error in this Macro and is not working, getting the following error:

>>> Working on analysis unit #1 (apple)

ERROR: The following columns were not found in the contributing tables: apple.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.03 seconds

cpu time 0.01 seconds

ERROR: File MBA.BASKET_DONORS.DATA does not exist.

ERROR: File MBA.CO_OCCURANCE.DATA does not exist.

WARNING: The data set MBA.CO_OCCURANCE may be incomplete. When this step was stopped there were 0 observations and 2 variables.

ERROR: Column ASSOC_ANALYSIS_UNIT could not be found in the table/view identified with the correlation name B.

ERROR: Column FREQ_CO_OCCUR could not be found in the table/view identified with the correlation name B.

ERROR: Column FREQ_CO_OCCUR could not be found in the table/view identified with the correlation name B.

ERROR: Column FREQ_CO_OCCUR could not be found in the table/view identified with the correlation name B.

ERROR: Column ASSOC_ANALYSIS_UNIT could not be found in the table/view identified with the correlation name B.

ERROR: File MBA.AFFINITY_CALC.DATA does not exist.

WARNING: The data set MBA.AFFINITY_CALC may be incomplete. When this step was stopped there were 0 observations and 2 variables.

ERROR: The following columns were not found in the contributing tables: ANALYSIS_UNIT_FREQ, ASSOC_ANALYSIS_UNIT,

ASSOC_ANALYSIS_UNIT_FREQ, CONFIDENCE, EXPECTED_CONFIDENCE, FREQ_CO_OCCUR, LIFT, SUPPORT, TOT_BASKET_DIMENSIONS.

[Reeza]

@rahul_wishard  You'll need to post some sample data so that we can replicate the issue. 

Instructions on how to create a sample data set can be found here:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

Also, given that this post is fairly old, it's probably worth starting your own thread and including a link to the macro. 

---

@rahul_wishard wrote:

There is an error in this Macro and is not working, getting the following error:

>>> Working on analysis unit #1 (apple)

ERROR: The following columns were not found in the contributing tables: apple.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.03 seconds

cpu time 0.01 seconds

ERROR: File MBA.BASKET_DONORS.DATA does not exist.

ERROR: File MBA.CO_OCCURANCE.DATA does not exist.

WARNING: The data set MBA.CO_OCCURANCE may be incomplete. When this step was stopped there were 0 observations and 2 variables.

ERROR: Column ASSOC_ANALYSIS_UNIT could not be found in the table/view identified with the correlation name B.

ERROR: Column FREQ_CO_OCCUR could not be found in the table/view identified with the correlation name B.

ERROR: Column FREQ_CO_OCCUR could not be found in the table/view identified with the correlation name B.

ERROR: Column FREQ_CO_OCCUR could not be found in the table/view identified with the correlation name B.

ERROR: Column ASSOC_ANALYSIS_UNIT could not be found in the table/view identified with the correlation name B.

ERROR: File MBA.AFFINITY_CALC.DATA does not exist.

WARNING: The data set MBA.AFFINITY_CALC may be incomplete. When this step was stopped there were 0 observations and 2 variables.

ERROR: The following columns were not found in the contributing tables: ANALYSIS_UNIT_FREQ, ASSOC_ANALYSIS_UNIT,

ASSOC_ANALYSIS_UNIT_FREQ, CONFIDENCE, EXPECTED_CONFIDENCE, FREQ_CO_OCCUR, LIFT, SUPPORT, TOT_BASKET_DIMENSIONS.

---

[rahul_wishard]

@Reeza I have created a new post: https://communities.sas.com/t5/SAS-Programming/Error-with-Market-Basket-Analysis-Macro/m-p/531884#M1...

Looking forward to your help! Thanks

[bq688]

As presented at the 2013 Midwest SAS Users Group meeting: http://billqualls.com/mba/index.html