SAS

No Image Uploaded

Handing Transactional Data


created on Aug. 11, 2019, 9:10 a.m.



ods excel file='&yourpath&yfilename.xlsx'; style=BARRETTSBLUE;

tittle "The Total Number of  each Product every Customer Bought in 2005";

proc tabulate data = work.transaction;

          class  'customer_id'n 'product'n ;     

          var      'number of products purchased in'n;    

          table    'customer_id'n, 'product'n=" "  *  'Number of products purchased in'n=" " * sum=" ";

run;

ods excel close;

Results