Yu Ma
Yu Ma

Reputation: 21

Error in Using Association Rule on SAS Enterprise Miner

I just started using SAS EM. And I imported an excel file with three variables into SAS EM: Customerid, Item and Sequence. Sequence stands for the sequence of transaction in this person's shopping history).

I linked the file import node with association node. However after I ran the association node, it kept throwing out error messages like this: "Must have at least 1 transaction data set(s)". It's the same error message with market basket analysis node. Any suggestions?

Upvotes: 2

Views: 5996

Answers (4)

n1tk
n1tk

Reputation: 2500

One option will be to select in the Role: Value "Transaction" ,in purple bellow, from default Value Raw for input data, e.g. see screenshot bellow:

enter image description here

Upvotes: 1

Mounirano
Mounirano

Reputation: 21

The correct answer is actually what both pratiksha and user3659823 have answered.

  1. You must define the role of your dataset as "Transaction".
  2. You should have "Target" and "ID" role in your dateset variables.

Upvotes: 2

user3659823
user3659823

Reputation: 11

In your transaction node,

Set your product's role to TARGET

your unique ID as ID

Upvotes: 1

pratiksha
pratiksha

Reputation: 21

when you define the data source define the role of the dataset as "transaction". this will be on Data Source Attributes page of "Data Source Wizard"

Upvotes: 2

Related Questions