Level 2 6. Creating a Three-Dimensional Tabular Report with PROC TABULATE a. Retrieve the starter program p112e10. Define a tabular report with the following characteristics: || 1) Customer_Gender defines the page dimension. 2) Customer_Group defines the row dimension. 3) The column dimension should display the number of customers and the percentage of customers in each category (COLPCTN). a Change the headers for the statistic columns with a KEYLABEL statement. Documentation about the KEYLABEL statement can be found in the SAS Help and Documentation from the Contents tab (SAS Products > Base SAS -> Base SAS 9.2 Procedures Guide - Procedures - The TABULATE Procedure). b. Submit the program to produce the following two-page report: PROC TABULATE Output Customers by Group and Gender Customer Gender F ffffffffffffffffffffffffffffff Number , Percentage, #fffffffffff ffffffffffff% ,Customer Group Name #ffffffffffffffffffffff%o Internet/Catalog ,Customers 4.00, 13.33, #fffffffff ffffff fififfffffffffff% Orion Club Gold ,members 11.00, 36.67, fffffffffff% 50.00 Orion Club members 15.00, ffffffff Customers by Group and Gender > Customer Gender M ffffffff--ffffffffffff. fffffffffft Number , Percentage, fffffffffffffffffffffffffffff%o ,Customer Group Name #ffffffffffffffffffff%o Internet/Catalog Customers 4.00, 8.51, #ffff fiflflffff%o ,Orion Club Gold members 10.00, 21.28, ffffffffffffffffffffff% ,Orion Club members 33.00, 70.21, ffffffff fil Level 2 6. Creating a Three-Dimensional Tabular Report with PROC TABULATE a. Retrieve the starter program p112e10. Define a tabular report with the following characteristics: || 1) Customer_Gender defines the page dimension. 2) Customer_Group defines the row dimension. 3) The column dimension should display the number of customers and the percentage of customers in each category (COLPCTN). a Change the headers for the statistic columns with a KEYLABEL statement. Documentation about the KEYLABEL statement can be found in the SAS Help and Documentation from the Contents tab (SAS Products > Base SAS -> Base SAS 9.2 Procedures Guide - Procedures - The TABULATE Procedure). b. Submit the program to produce the following two-page report: PROC TABULATE Output Customers by Group and Gender Customer Gender F ffffffffffffffffffffffffffffff Number , Percentage, #fffffffffff ffffffffffff% ,Customer Group Name #ffffffffffffffffffffff%o Internet/Catalog ,Customers 4.00, 13.33, #fffffffff ffffff fififfffffffffff% Orion Club Gold ,members 11.00, 36.67, fffffffffff% 50.00 Orion Club members 15.00, ffffffff Customers by Group and Gender > Customer Gender M ffffffff--ffffffffffff. fffffffffft Number , Percentage, fffffffffffffffffffffffffffff%o ,Customer Group Name #ffffffffffffffffffff%o Internet/Catalog Customers 4.00, 8.51, #ffff fiflflffff%o ,Orion Club Gold members 10.00, 21.28, ffffffffffffffffffffff% ,Orion Club members 33.00, 70.21, ffffffff fil
