Two Parameters for Association Rules Algorithm


  • I'm working on association rules algorithm dmx.

    every sample is just on parameter. Like Product name. Then algorithm find correlation with products.

    But in my db has many products that is the same name but different supplier name. So i must to calculate and find relation by supplier name and product name. Do you have any idea or sample?

    Thursday, August 22, 2013 1:31 PM

All replies

  • Hello -- if you look at the "Sample Excel Data" which comes with the Excel data mining add-in, there is a table in there which shows the layout.  There would be one record per product, and then you could have multiple records per supplier.

    Or you could be saying that the transactions have multiple combinations of products and suppliers.  In that case, you can perform the analysis either on the supplier or the product.  Since the product names are same across suppliers, I would concatenate product and supplier together into a single field.

    Mark Tabladillo PhD (MVP, SAS Expert; MCT, MCITP, MCAD .NET)

    Tuesday, April 22, 2014 10:31 PM