Hello everyone,
I'm using SAS Base/ SAS Enterprise Guide and I'm stuck.
I need to create the Association Rules matrix to calculate the support, lift, confidence and other association metrics.
My table is similar to: (one line per client with all the products associated to)
data test;
input item1 item2 item3 item4 ;
datalines ;
1 0 1 0
1 1 1 0
1 0 1 0
1 0 1 1
;
As you know for the market basket analysis I want something like that:
item1 item2 item3 item4
item1 4 1 4 1
item2 1 1 1 0
item3 4 1 4 1
item4 1 0 4 4
Thank you for your help.
Here's a nifty little trick using PROC CORR:
data test;
input item1 item2 item3 item4 ;
datalines ;
1 0 1 0
1 1 1 0
1 0 1 0
1 0 1 1
;
ods output sscp=want;
proc corr data=test sscp;
var item1-item4;
run;
proc print data=want;
run;
PS. Thank you for providing sample data as a data step!
@alorenzo wrote:
Hello everyone,
I'm using SAS Base/ SAS Enterprise Guide and I'm stuck.
I need to create the Association Rules matrix to calculate the support, lift, confidence and other association metrics.
My table is similar to: (one line per client with all the products associated to)
data test;
input item1 item2 item3 item4 ;
datalines ;
1 0 1 0
1 1 1 0
1 0 1 0
1 0 1 1
;As you know for the market basket analysis I want something like that:
item1 item2 item3 item4
item1 4 1 4 1
item2 1 1 1 0
item3 4 1 4 1
item4 1 0 4 4
Thank you for your help.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.