topic Re: Association Analysis and Market Basket Analysis in Statistical Procedures

Association Analysis and Market Basket Analysis

frupaul — Mon, 18 Dec 2017 11:40:39 GMT

Hi All,

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

Thanks,

Paul

Re: Association Analysis and Market Basket Analysis

Reeza — Mon, 18 Dec 2017 15:44:23 GMT

Yes, there is, via Google

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

Re: Association Analysis and Market Basket Analysis

frupaul — Mon, 18 Dec 2017 22:42:21 GMT

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?

Re: Association Analysis and Market Basket Analysis

Reeza — Tue, 19 Dec 2017 01:12:10 GMT

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

Re: Association Analysis and Market Basket Analysis

sld — Tue, 19 Dec 2017 02:33:20 GMT

Try this link

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

Things change in 14 years 🙂

Re: Association Analysis and Market Basket Analysis

rahul_wishard — Thu, 31 Jan 2019 11:04:02 GMT

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 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.

Re: Association Analysis and Market Basket Analysis

Reeza — Thu, 31 Jan 2019 16:12:18 GMT

@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-data-AKA-generate/ta-p/258712

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.

Re: Association Analysis and Market Basket Analysis

rahul_wishard — Fri, 01 Feb 2019 05:14:53 GMT

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

Looking forward to your help! Thanks

Re: Association Analysis and Market Basket Analysis

bq688 — Thu, 30 Jan 2020 17:45:55 GMT

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