Learn more about SQL Server tools

mssqltips logo
giveaway
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

SQL Server 2012 Analysis Services Association Rules Data Mining Example


By:   |   Read Comments (3)   |   Related Tips: > Analysis Services Development

Problem

The output from the Association Rules data mining model in SQL Server Analysis Services can be difficult to understand in terms of the calculations named Probability and Importance.  In this tip we will walk through an example of how to get the Probability and Importance calculations to help you better understand how to use this feature in SSAS.

Solution

In this tip, we show how to create a simple data mining model using the Association Rules algorithm in SQL Server Analysis Services 2012. At the conclusion, T-SQL statements are provided to show how the mining model calculates the probability and importance displayed in the mining model viewer. The solution presented here uses data from a banking example provided by Bamshad Mobasher at DePaul University.

The first step is to create a table and load it with data using the T-SQL sample below.

create table dbo.tblAssociationRulesExample 
(
  UniqueID integer identity(1,1) Primary Key,
  AgeRange varchar(8) not null,
  Gender varchar(6) not null,
  Region varchar(10) not null,
  Income varchar(8) not null,
  Married varchar(3) not null,
  NumberOfChildren int not null,
  IsCarOwner varchar(3) not null,
  HasSavingsAccount varchar(3) not null,
  HasCurrentAccount varchar(3) not null,
  HasMortgage varchar(3) not null,
  DidBuyAPersonalEquityPlan varchar(3) not null
)
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','NO',1,'NO','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',3,'YES','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Low','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',3,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','YES',0,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','NO',0,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Middle','YES',2,'YES','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','High','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','High','YES',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Low','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',2,'NO','NO','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Middle','YES',0,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',0,'NO','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',2,'NO','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','NO',3,'YES','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','Low','YES',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Low','YES',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',2,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Low','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Middle','NO',3,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Middle','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',3,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Low','NO',0,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','Middle','NO',2,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Middle','YES',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',0,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','High','NO',2,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Middle','YES',0,'YES','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',2,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',2,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','NO',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',2,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','NO',2,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Low','YES',2,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',2,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',0,'NO','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Middle','NO',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','High','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','NO',3,'NO','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',0,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Middle','NO',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',1,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','NO',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','YES',2,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',3,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',3,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Low','YES',2,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','NO',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Middle','NO',2,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','NO',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',2,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','NO',3,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Middle','NO',3,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',1,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Low','YES',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Low','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','YES',0,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',2,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',1,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Middle','NO',2,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Middle','NO',0,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',0,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'NO','NO','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Middle','YES',2,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','NO',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','YES',0,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',3,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','High','YES',0,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',2,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Middle','YES',3,'YES','NO','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',0,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Low','YES',2,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',3,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','NO',0,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','YES',3,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','NO',2,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',1,'NO','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Middle','NO',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','High','NO',3,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',2,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',3,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','NO',2,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','Middle','YES',3,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','Low','NO',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','Middle','YES',0,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','High','YES',2,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',2,'YES','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','NO',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',3,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',1,'YES','NO','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','High','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','High','YES',0,'NO','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','YES',2,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','Middle','YES',0,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','SUBURBAN','Middle','YES',3,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',2,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','High','YES',2,'NO','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Middle','YES',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Low','NO',2,'YES','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','SUBURBAN','Low','YES',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Low','YES',0,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',0,'NO','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','NO',3,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','NO',1,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',0,'NO','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',1,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',1,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',1,'NO','NO','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','NO',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',2,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',3,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',0,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'NO','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',2,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','High','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',2,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','NO',0,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','YES',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'NO','NO','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',2,'YES','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','High','YES',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',1,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','YES',3,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','Middle','YES',2,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Low','YES',1,'NO','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',2,'NO','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','NO',3,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'NO','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','NO',0,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','SUBURBAN','Low','YES',0,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',3,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',0,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','NO',2,'YES','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','High','YES',3,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Middle','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Middle','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','NO',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Middle','NO',1,'NO','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','YES',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Middle','NO',3,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','NO',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','High','NO',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',2,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','YES',2,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','YES',2,'YES','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','YES',2,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Middle','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',3,'YES','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',3,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',3,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','NO',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',2,'NO','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',1,'NO','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','NO',3,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Low','NO',0,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Middle','NO',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',2,'NO','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','NO',3,'NO','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','NO',0,'NO','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Middle','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Middle','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',0,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',3,'YES','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','High','NO',2,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Middle','YES',1,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Middle','NO',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Middle','NO',0,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',1,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'NO','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',1,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',3,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',3,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','YES',0,'NO','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',3,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','NO',0,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','High','YES',2,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',0,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Middle','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Middle','NO',2,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',2,'NO','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','NO',2,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',1,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',0,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',0,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','YES',3,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','NO',3,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','NO',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',1,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','NO',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','NO',2,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','NO',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Low','YES',0,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Low','NO',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','NO',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',2,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Low','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','NO',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Low','YES',0,'YES','NO','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',1,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','NO',0,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',1,'NO','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','NO',1,'NO','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',3,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','YES',3,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',2,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Middle','YES',0,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Low','YES',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','SUBURBAN','Low','YES',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',1,'NO','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',2,'NO','NO','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',1,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','Middle','YES',2,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','High','YES',1,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','YES',0,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','YES',0,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',0,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Low','NO',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Middle','NO',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Middle','NO',1,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Middle','YES',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','YES',2,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',3,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Low','YES',1,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','High','NO',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Low','YES',3,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Middle','YES',2,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','High','YES',1,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',2,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',1,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',3,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','NO',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',0,'NO','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','High','YES',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','NO',1,'NO','NO','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','NO',2,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','YES',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',3,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',3,'YES','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','NO',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','NO',1,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',0,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','NO',0,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',3,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Low','YES',2,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','Middle','NO',0,'YES','NO','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Low','YES',3,'YES','NO','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','YES',0,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','NO',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',0,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','NO',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','NO',3,'YES','NO','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',0,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','NO',0,'NO','NO','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',3,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Middle','YES',3,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','High','NO',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Low','YES',1,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','YES',2,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',1,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','NO',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','High','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','NO',1,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',1,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Middle','YES',2,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Low','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','NO',1,'NO','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',1,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',3,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',2,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',1,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','NO',2,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',0,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','High','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Middle','YES',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',2,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'YES','NO','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',1,'YES','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','SUBURBAN','Low','YES',1,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',1,'NO','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','High','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','YES',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',2,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','High','YES',3,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Middle','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',3,'YES','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',0,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',0,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','NO',1,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','High','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','Middle','YES',0,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','YES',2,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',2,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','SUBURBAN','Low','NO',3,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Low','YES',0,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Middle','NO',3,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Low','YES',2,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','NO',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',2,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','NO',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',2,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',2,'NO','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','High','NO',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','NO',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',0,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',0,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',3,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',2,'NO','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',1,'YES','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','NO',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',0,'YES','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Middle','YES',3,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',0,'NO','NO','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',2,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','High','NO',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',0,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',3,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',1,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Middle','YES',0,'YES','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Low','YES',0,'NO','NO','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','SUBURBAN','Low','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','High','NO',2,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','YES',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',0,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',3,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','High','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','NO',3,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','NO',0,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','NO',0,'NO','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Middle','YES',1,'NO','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','NO',3,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',3,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',2,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','NO',3,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',0,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Low','YES',0,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',2,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','NO',1,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Middle','YES',2,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','Middle','YES',1,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','High','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','NO',1,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','NO',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','NO',1,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','NO',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',1,'YES','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','YES',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','High','YES',1,'YES','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Low','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','NO',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',0,'YES','NO','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Low','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','High','YES',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',1,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','Middle','YES',3,'NO','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Middle','YES',0,'YES','NO','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',3,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Low','YES',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','Middle','YES',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','NO',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','SUBURBAN','Low','NO',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',1,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Low','YES',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Middle','YES',0,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',0,'NO','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','NO',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Middle','NO',3,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',0,'NO','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','SUBURBAN','Middle','NO',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','High','YES',0,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',0,'YES','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','High','YES',2,'YES','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','YES',2,'YES','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','NO',3,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Middle','NO',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','YES',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',3,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','NO',1,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','High','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','YES',1,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','NO',2,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','High','YES',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Middle','YES',3,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','NO',2,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',0,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',0,'YES','NO','YES','YES','YES')

The first five rows of data is shown below. This data will be used as the input for the data mining algorithm.

Association Rules Data Mining Example in SQL Server 2012 Analysis Services

In Visual Studio (also known from the start menu as SQL Server Data Tools), create a new Analysis Services Multidimensional and Data Mining Project. In this tip, we will name the project Association Rules Example. Click on OK when finished with the New Project window.

SQL Server Data Tools

In the Solution Explorer window, right-click on the Data Sources folder and choose "New Data Source..." to initiate the Data Source Wizard. Click on "Next".

right-click on the Data Sources folder and choose "New Data Source..."

Choose your data connection, if one exists. If a Data connection does not exist, click on "New..." to create a new data connection. In this example, we are using a connection to the Tips database on the localhost. Click on "Next".

If a Data connection does not exist, click on "New..."

On the Impersonation Information screen, click on "Use a specific Windows user name and password." Enter your username and password. Click on "Next".

"Use a specific Windows user name and password."

On the Completing the Wizard screen, the data source name can be changed if desired. Click on "Finish".

the data source name can be changed if desired.

In the Solution Explorer window, right-click on the Data Source Views folder and choose "New Data Source View..." to launch the Data Source View Wizard. Click on "Next".

right-click on the Data Source Views folder and choose "New Data Source View..."

On the Select a Data Source page in the Relational data sources window, select the data source we created in the above step. Click on "Next".

select the data source we created in the above step. Click on "Next".

On the Select Tables and Views page, move tblAssociationRulesExample from the Available Objects box to the Included object box by selecting tblAssociationRulesExample in the Available objects box and then clicking on the ">" box. Click on "Next".

move tblAssociationRulesExample from the Available Objects box to the Included object box

On the Completing the Wizard page, give the Data Source View a name and click on "Finish". On the Name Matching page, check the box for "Create logical relationships by matching columns." In the Foreign key matches box, press the "Same name as primary key" button. Click on "Next".

On the Completing the Wizard page, give the Data Source View a name and click on "Finish".

The Solution Explorer should appear as it does below with one Data Source and one Data Source View defined.

one Data Source and one Data Source View defined.

In the Solution Explorer window, right-click on the Mining Structures folder and choose "New Mining Structure..." to launch the Data Mining Wizard. Click on "Next".

choose "New Mining Structure..."

On the Select the Definition Method page, press the radio button labeled "From existing relational database or data warehouse". Click on "Next".

"From existing relational database or data warehouse".

On the Create the Data Mining Structure page, press the radio button labeled "Create mining structure with a mining model". Choose the "Microsoft Association Rules" data mining technique from the drop-down box.

Choose the "Microsoft Association Rules" data mining technique from the drop-down box.

On the Select Data Source View page, choose "Tips" from the Available data source views. Please note this is the data source view we created earlier. Click on "Next".

On the Select Data Source View page, choose "Tips"

On the Specify Table Types page, make sure the Case box is checked and the Nested box is unchecked for the table named tblAssociationRulesExample. Click on "Next".

On the Specify Table Types page, make sure the Case box is checked

On the Specify the Training Data page, ensure that the check box is checked in the Key column for the UniqueID - this should happen by default. Also, in the Predictable column, check the check box for the DidBuyAPersonalEquityPlan attribute. The remainder of the columns should have the check box checked in the Input column. When finished the page should appear as shown below. Click on "Next".

On the Specify the Training Data page, ensure that the check box is checked in the Key column

On the Specify Columns' Content and Data Type page, we see the columns to be used in the mining model structure, along with their content and data types. Click on "Next".

On the Specify Columns' Content and Data Type page, we see the columns to be used in the mining model structure

On the Create Testing Set page, we will set the "Percentage of data for testing" and "Maximum number of cases in testing data set" to zero for this example. Please note that there needs to be a set of data reserved for testing or use 10-fold cross validation to prevent overfitting the data mining model to the training data. Click on "Next".

set the "Percentage of data for testing" and "Maximum number of cases in testing data set" to zero for this example.

On the Completing the Wizard page, the name of the mining structure and model can be changed. Click on "Finish".

the name of the mining structure and model can be changed

The Solution Explorer window should appear as shown below.

The Solution Explorer window should appear as shown

Before continuing, examine the Visual Studio project's properties page to ensure that the deployment location is a server that has Analysis Services running and that you have permission to create and process Analysis Services objects on the server.

examine the Visual Studio project's properties page

In Visual Studio, the Mining Structure tab of the data mining model should appear as shown below. Notice there are five tabs on the page, Mining Structure, Mining Models, Mining Model Viewer, Mining Accuracy Chart and Mining Model Prediction.

In Visual Studio, the Mining Structure tab of the data mining model should appear as shown

Click on the Mining Model Viewer tab. A message box should appear asking if you would "like to build and deploy the project first". Click on Yes.

Click on the Mining Model Viewer tab

The Deployment Progress window will appear and a message should display stating that the "mining model must be processed before you can browse its content." The box also gives a warning that "it could take some time to process the mining model depending on the amount of data." Since we only have 600 records in this example, the processing should only take a few seconds. When asked if "you wish to continue", click on "Yes".

the "mining model must be processed before you can browse its content."

Next the Process Mining Model window should appear. We will leave all of the settings at their default values. Click on "Run..."

Next the Process Mining Model window should appear

The Process Progress window will appear detailing the processing that is occurring on the server. When the process has succeeded, click on "Close" to return to the Process Mining Model window. Click on "Close" in the Process Mining Model window to return to Visual Studio. You might see a window asking you to wait while the model is loading.

The Process Progress window will appear detailing the processing that is occurring on the server

The Mining Model Viewer tab should now appear as shown below. The rules can be sorted by Probability, Importance and the Rule.

The Mining Model Viewer tab should now appear as shown below

While the mathematics to explain the probability and importance values with complex rules can get complicated, I will explain these calculations using the simple rule that Region = SUBURBAN implies that Did Buy A Personal Equity Plan = YES.

While the mathematics to explain the probability and importance values with complex rules can get complicated

The T-SQL below shows how the Probability is calculated.

declare @SuburbanYesCount float
declare @SuburbanCount float
--Get the total count for the rule Region='SUBURBAN' implies DidBuyAPersonalEquityPlan='YES'
set @SuburbanYesCount=(select cast(count(*) as float) from dbo.tblAssociationRulesExample 
                       where Region='SUBURBAN' and DidBuyAPersonalEquityPlan='YES')
--Get the total count for all Region='SUBURBAN'
set @SuburbanCount=(select cast(count(*) as float) from dbo.tblAssociationRulesExample 
                    where Region='SUBURBAN')
select @SuburbanYesCount as CountOfSuburbanAndYes, 
       @SuburbanCount as CountOfAllSuburban,
       round(@SuburbanYesCount/@SuburbanCount,3) as Probability


The T-SQL below shows how the Importance is calculate

The T-SQL below shows how the Importance is calculated.

declare @SuburbanYesCount float
declare @NotSuburbanNoCount float
declare @SuburbanNoCount float
declare @NotSuburbanYesCount float
declare @Numerator float
declare @Denominator float
-- The algorithm adds one to each count to prevent divide by zero errors
set @SuburbanYesCount=(select cast(count(*)+1 as float) from dbo.tblAssociationRulesExample 
                       where Region='SUBURBAN' and DidBuyAPersonalEquityPlan='YES')
set @NotSuburbanNoCount=(select cast(count(*)+1 as float) from dbo.tblAssociationRulesExample 
                         where Region<>'SUBURBAN' and DidBuyAPersonalEquityPlan='NO')
set @SuburbanNoCount=(select cast(count(*)+1 as float) from dbo.tblAssociationRulesExample 
                      where Region='SUBURBAN' and DidBuyAPersonalEquityPlan='NO')
set @NotSuburbanYesCount=(select cast(count(*)+1 as float) from dbo.tblAssociationRulesExample 
                          where Region<>'SUBURBAN' and DidBuyAPersonalEquityPlan='YES')
--echo the values
select @SuburbanYesCount as SuburbanYesCount, 
       @NotSuburbanNoCount as NotSuburbanNoCount, 
       @SuburbanNoCount as SuburbanNoCount,
       @NotSuburbanYesCount as NotSuburbanYesCount
set @Numerator=(select @SuburbanYesCount/(@SuburbanYesCount+@SuburbanNoCount))
set @Denominator=(select @NotSuburbanYesCount/(@NotSuburbanYesCount+@NotSuburbanNoCount))
select @Numerator as Numerator, 
       @Denominator as Denominator, 
       @Numerator/@Denominator as Quotient
select round(LOG10(@Numerator/@Denominator),3) as Importance


SQL Server 2012 Analysis Services.
Next Steps

Explore the different association rules to discover interesting patterns in the data and read the following tips to find out more about data mining functionality in SQL Server 2012 Analysis Services.



Last Update:






About the author
MSSQLTips author Dallas Snider Dr. Dallas Snider is an Assistant Professor in the Computer Science Department at the University of West Florida and has 18+ years of SQL experience.

View all my tips





More SQL Server Solutions











Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


SQL tips:

*Enter Code refresh code     



Wednesday, June 11, 2014 - 11:11:38 AM - Bruce K Back To Top

Great article.   I also would like to know what the nested is for...

Also - did we not set up a training set due to the small number of data points?   with out the test set we cannot do lift charts which I think is a great tool and it would be great to go through that example.

 

Thank you


Friday, March 07, 2014 - 8:23:00 AM - Koen Verbeeck Back To Top

Thanks for the article.

On the Specify Table Types page, why does the nested box have to be unchecked?


Friday, March 07, 2014 - 2:46:28 AM - lixia Back To Top

 

You are a great teacher !


Learn more about SQL Server tools