To keep matters simple, let's try and study the affinity between two products/services. This can also be phrased as having a set size of two. The data that we have has customers with up to eight products/services in their baskets. Hence, we could have up to a set size of eight. Currently, the data we have resembles a wide state, as represented in Figure 7.3. We will transpose this data, find the count of various products/services, and create some macro variables to store information. The macro variables will primarily hold the count of products and services, and the total number of customers, and a couple of others will aid us in executing the macro.
Here is the data transformation and macro variable initiation: ...
