BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
frupaul
Quartz | Level 8

Hi All,

 

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

 

Thanks,

 

Paul

1 ACCEPTED SOLUTION

Accepted Solutions
sld
Rhodochrosite | Level 12 sld
Rhodochrosite | Level 12

Try this link

 

 

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

 

Things change in 14 years 🙂

View solution in original post

8 REPLIES 8
frupaul
Quartz | Level 8
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
Super User

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

sld
Rhodochrosite | Level 12 sld
Rhodochrosite | Level 12

Try this link

 

 

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

 

Things change in 14 years 🙂

rahul_wishard
Calcite | Level 5

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
Super User
@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:
 
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.

bq688
Calcite | Level 5

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

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 8 replies
  • 4600 views
  • 0 likes
  • 5 in conversation