Steps Necessary To Pass The A00-231 Exam from Training Expert DumpsTests [Q47-Q65]

Q47. After a SAS program is submitted, the following is written to the SAS log:

What changes should be made to the KEEP statement to correct the errors in the LOG?

Q48. The following SAS program is submitted:
data one;
addressl = ‘214 London Way’;
run;
data one;
set one;
address = tranwrd(address1, ‘Way’, ‘Drive’); run;
What are the length and value of the variable ADDRESS?

Q49. The following SAS program is submitted:
data ONE TWO SASUSER.TWO
set SASUSER.ONE;
run;
Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?

Q50. The following SAS program is submitted:
data work.test;
array items{3} _temporary_;
run;
What are the names of the variable(s) in the WORKTEST data set?

Q51. Given the raw data record in the file phone.txt:

Which SAS statement completes the program and results in a value of “James Stevens” for the variableFullName?

Q52. Given the following raw data records in TEXTFILE.TXT:

The following output is desired:

Which SAS program correctly produces the desired output?

Q53. The contents of two SAS data sets named EMPLOYEE and SALARY are listed below:
EMPLOYEE SALARY
name age name salary
Bruce 30 Bruce 40000
Dan 35 Bruce 35000
Dan 37000
Dan .
The following SAS program is submitted:
data work.empsalary;
merge work.employee (in = inemp)
work.salary (in = insal);
by name;
if inemp and insal;
run;
How many observations will the data set WORK.EMPSALARY contain?

Q54. Consider the following data step:

The computed variables City and State have their values assigned using two different methods, a RETAIN statement and an Assignment statement.
Which statement regarding this program is true?

Q55. Which one of the following SAS procedures displays the data portion of a SAS data set?

Q56. The contents of the raw data file PRODUCT are listed below:
——–10——-20——-30
24613 $25.31
The following SAS program is submitted:
data inventory;
infile ‘product’;
input idnum 5. @10 price;
run;
Which one of the following is the value of the PRICE variable?

Q57. Given the SAS data set WORK.ORDERS:

The variable order_id is numeric; customer is character; and shipped is numeric, contains a SAS date value, and is shown with the DATE9. format. A programmer would like to create a new variable, ship_note, that shows a character value with the order_id, shipped date, and customer name. For example, given the first observation ship_note would have the value “Order 9341 shipped on 02FEB2009 to Josh Martin”.
Which of the following statement will correctly create the value and assign it to ship_note?

Q58. The SAS data set WORK.ONE contains a numeric variable named Num ana character variable named Char:
WORK.ONE
Num Char
—— ——
1 23
3 23
1 77
The following SAS program is submitted:
proc print data=WORK.ONE;
where Num=’1′;
run;
What is output?

Q59. Given the SAS data set WORK.ONE:

The following SAS program is submitted:

The data set WORK.TWO is created, where Day would be 1 for Sunday, 2 for Monday, 3 for Tuesday, … :

Which expression successfully completed the program and creates the variable DAY?

Q60. The contents of the raw data file FURNITURE are listed below:
——–10——-20——-30
chair,,table
chair,couch,table
The following SAS program is submitted:
data stock;
infile ‘furniture’ dsd;
input item1 $ item2 $ item3 $;
run;
Which one of the following is the value of the variable named ITEM2 in the first observation of the output data set?

Q61. The following SAS program is submitted:
data work.pieces;
do while (n lt 6);
n + 1;
end;
run;
Which one of the following is the value of the variable N in the output data set?

Q62. Which one of the following SAS system options displays the time on a report?

Q63. The contents of the raw data file EMPLOYEE are listed below:
——–10——-20——-30
Ruth 39 11
Jose 32 22
Sue 30 33
John 40 44
The following SAS program is submitted:
data test;
infile ’employee’;
input employee_name $ 1-4;
if employee_name = ‘Sue’ then input age 7-8; else input idnum 10-11;
run;
Which one of the following values does the variable AGE contain when the name of the employee is “Sue”?

Q64. The following SAS program is submitted:
data one;
date = ’04juI2005’d;
format date weekdate.; run;
proc print data = one; run;
What output is generated?

Q65. A SAS program is submitted and the following SAS log is produced:
2 data gt100;
3 set ia.airplanes
4 if mpg gt 100 then output;
22 202
ERROR: File WORK.IF.DATA does not exist.
ERROR: File WORK.MPG.DATA does not exist.
ERROR: File WORK.GT.DATA does not exist.
ERROR: File WORK.THEN.DATA does not exist.
ERROR: File WORK.OUTPUT.DATA does not exist.
ERROR 22-322: Syntax error, expecting one of the following: a name,
a quoted string, (, ;, END, KEY, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
ERROR 202-322: The option or parameter is not recognized and will be ignored.
5 run;
The IA libref was previously assigned in this SAS session.
Which one of the following corrects the errors in the LOG?