13.2 - Example: Sales Data

Example 13-1: Sales Section

The example data comes from a firm that surveyed a random sample of n = 50 of its employees in an attempt to determine which factors influence sales performance. Two collections of variables were measured:

  • Sales Performance:
    • Sales Growth
    • Sales Profitability
    • New Account Sales
  • Test Scores as a Measure of Intelligence
    • Creativity
    • Mechanical Reasoning
    • Abstract Reasoning
    • Mathematics

There are p = 3 variables in the first group relating to Sales Performance and q = 4 variables in the second group relating to Test Scores.

Download the text file containing the data here: sales.txt

Using SAS

Canonical Correlation Analysis is carried out in SAS using a canonical correlation procedure that is abbreviated as cancorr. Let's look at how this is carried out in the SAS Program below

Download the SAS program here: sales.sas or click on the copy icon below.


options ls=78;
title "Canonical Correlation Analysis - Sales Data";
data sales;
  infile "D:\Statistics\STAT 505\data\sales.txt";
  input growth profit new create mech abs math;
  run;
proc cancorr out=canout vprefix=sales vname="Sales Variables" 
                       wprefix=scores wname="Test Scores";
  var growth profit new;
  with create mech abs math;
  run;
proc gplot;
  axis1 length=3 in;
  axis2 length=4.5 in;
  plot sales1*scores1 / vaxis=axis1 haxis=axis2;
  symbol v=J f=special h=2 i=r color=black;
  run;
View the video explanation of the SAS code.