LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2009, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 5 Oct 2009 13:11:40 -0400
Reply-To:     Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject:      Re: To find the repeating or same set of products in the orders

how do your data look like? Please give a example of what you have.

eg:

cust_id p1 p2 p3 p4 .... p10 1 0 2 0 5 3 2 1 5 2 0 0 3 0 0 3 0 8

for the number of ordered pieces of p1, p2, p3, ...

or in any other form?

Gerhard

On Mon, 5 Oct 2009 09:21:26 -0700, kondal <kondal717@GMAIL.COM> wrote:

>Dear Friends >To find the repeating or same set of products in the orders. or the >repeating patterns or groups of the same orders made by the customers. > >Example: >first customer ordered products are 1,2,3,4,5,6,7,8,9,10 >second customer ordered products are products 1,4,6,7,8 >third customer ordered products are products 1,2,4,6,9 >fourth customer ordered products are products 1,2,3,4,5, >fifth customer ordered products are products 6,7,8,9 >Like 2500 customers are ordered different Products. > >Now I would like to know 2 or more same set or Cluster or group of >products ordered; >if it is 2 products then , products (1, 4) >if its more than 2 , products (1,4,6) is one group or cluster of >products which are ordered together for so many times and like wise >products (6,7,8,9) is one group , products (1,2,3,4,5) is one group , >products ( 1,2,4) is one cluster, like wise........ > >Help me in code


Back to: Top of message | Previous page | Main SAS-L page