SAS Certified Base Programmer 123 Questions (101)
The following SAS program is submitted:
proc freq data=sales;
<insert TABLES statement here>
run;
Exhibit: output from the FREQ procedure.
| The FREQ Procdure Table of Region by Product |
||||
| Region | Product | |||
| Frequency Percent Row Pct Col Pct |
Boot | Sandal | Slipper | Total |
| Africa | 8 12.70 33.33 38.10 |
8 12.70 33.33 38.10 |
8 12.70 33.33 38.10 |
24 38.10 |
| Asia | 2 3.17 33.33 9.52 |
2 3.17 33.33 9.52 |
2 3.17 33.33 9.52 |
6 9.52 |
| Canada | 5 7.94 33.33 23.81 |
5 7.94 33.33 23.81 |
5 7.94 33.33 23.81 |
15 23.81 |
| Pacific | 6 9.52 33.33 28.57 |
6 9.52 33.33 28.57 |
6 9.52 33.33 28.57 |
18 28.57 |
| Total | 21 33.33 |
21 33.33 |
21 33.33 |
63 100.00 |
Which one of the following statements completes the program and produces the output?
A. tables region product;
B. tables region* product;
C. tables product region;
D. tables product region*;
SAS Certified Base Programmer 123 Questions (100)
Which one of the following SAS system options prevents the page number from appearing on a report?
A. NONUM
B. NOPAGE
C. NONUMBER
D. NOPAGENUM
SAS Certified Base Programmer 123 Questions (99)
Exhibit: view two reports. Assume permanent variable labels have been assigned.
| Output we are getting | ||
| Regin Asia | Subsidiary | Total Sales |
| Bangkok | $1,996 | |
| Bangkok | $3,033 | |
| Bangkok | $3,230 | |
| Bangkok | $3,019 | |
| Bangkok | $5,389 | |
| Seoul | $60,712 | |
| Seoul | $11,754 | |
| Seoul | $116,333 | |
| Seoul | $4,978 | |
| Seoul | $149,013 | |
| Seoul | $937 | |
| Seoul | $20,448 | |
| Seoul | $78,234 | |
| Tokyo | $1,155 | |
——————————————————————————————————————————————-
| Output we want! | ||
| Regin Asia | Subsidiary | Total Sales |
| Bangkok | $16,667 | |
| Seoul | $442,409 | |
| Tokyo | $1,155 | |
The following SAS program is submitted and produces the first report:
proc report data = sasuser.shoes nowd;
column region subsidiary sales;
define subsidiary / display;
define region / group;
define sales / sum;
run;
Which one of the following corrects the program above to produce the second report shown in the exhibit?
A. Define the variable SUBSIDIARY with a SUM usage.
B. Define the variable SUBSIDIARY with a GROUP usage.
C. Define the variable SUBSIDIARY with an ORDER usage.
D. Define the variable SUBSIDIARY with an ACROSS usage.
SAS Certified Base Programmer 123 Questions (98)
The following SAS program is submitted:
footnote1 'Sales Report for last Mounth'; footnote2 'Selected Products Only'; footnote3 'All Regions'; footnote4 'All Figure in Thousands of Dollars'; proc print data = sasuser.shoes; footnote2 'All products'; run;
Which one of the following contains the footnote text that is displayed in the report?
A.
All Products
B.
Sales Report for Last Month
All Products
C.
All Products
All Regions
All Figures in Thousands of Dollars
D.
Sales Report for Last Month
All Products
All Regions
All Figures in Thousands of Dollars
SAS Certified Base Programmer 123 Questions (97)
The following SAS program is submitted:
proc means data = sasuser.houses std mean max; var sqfeet; run;
Which one of the following is needed to display the standard deviation with only two decimal places?
A. Add the option MAXDEC = 2 to the MEANS procedure statement.
B. Add the statement MAXDEC = 7.2; in the MEANS procedure step.
C. Add the statement FORMAT STD = 7.2; in the MEANS procedure step.
D. Add the option FORMAT = 7.2 option to the MEANS procedure statement.