Online Access Free A00-231 Exam Questions

The following SAS program is submitted:
data work.retail;
cost = '20000';
total= .10* cost
run;
What is the result?

• A.The value of the variable TOTAL in the output data set is 2000. No messages are written to the SAS log.
• B.The value of the variable TOTAL in the output data set is missing. An error message is written to the SAS log.
• C.The variable TOTAL in the output data set has no value. The program fails to execute due to a syntax error.
• D.The value of the variable TOTAL in the output data set is 2000. A note that conversion has taken place is written to the SAS log.

Given the raw data file YEARAMT:
----|---10---|---20---|----30
1901 2
1905 1
1910 6
1925 .
1941 1
The following SAS program is submitted:
data coins;
infile 'yearamt';
input year quantity;
<insert statement(s) here>
run;
Which statement(s) completed the program and produced a non-missing value for the variable TOTQUANTITY in the final observation of the output data set?

• A.retain totquantity0; totquantity = totquantity + quantity;
• B.totquantity + quantity;
• C.retain totquantity; totquantity = totquantity + quantity;
• D.totquantity = sum(totquantity + quantity);

The following SAS program is submitted:
data WORK.AUTHORS;
array Favorites{3} $ 8 ('Shakespeare','Hemingway','McCaffrey');
run;
What is the value of the second variable in the dataset WORK.AUTHORS?

• A.'' (a missing value)
• B.Hemingwa
• C.The program contains errors. No variables are created.
• D.Hemingway

Given the SAS data set WORKAWARDS:
WORK.AWARDS
FNAMEPOINTSMONTH
----------------------------------
Amy24
Amy17
Gerard33
Wang33
Wang112
Wang18
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
How are the observations sorted?

• A.ENAME POINTS MONTH Wang33 Wang112 Wang18 Gerard33 Amy24 Amy17
• B.ENAME POINTS MONTH Amy24 Amy17 Gerard33 Wang33 Wang18 Wang112
• C.ENAME POINTS MONTH Wang112 Wang18 Wang33 Gerard33 Amy17 Amy24
• D.ENAME POINTS MONTH Wang33 Wang18 Wang112 Gerard33 Amy24 Amy17

The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below:
WORK.EMPLOYEE WORK.SALARY
fname age name salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
by fname;
totsal + salary;
run;
Which one of the following statements completes the merge of the two data sets by the FNAME variable?

• A.merge work.employeework.salary (fname = name);
• B.merge work.employeework.salary (name = fname);
• C.merge work.employeework.salary (rename = (fname = name));
• D.merge work.employeework.salary (rename = (name = fname));