Analysis of a set size of two

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:

Proc transpose data=wide out=long (rename=(col1=PRODUCTS) drop=_label_); 
By custid; 
Var pr1-pr8; 
run; 
 
proc sql;  
   create table...