Clear your concepts with A00-231 Questions Before Attempting Real exam [Q93-Q116]

NEW QUESTION 93
The following SAS program is submitted:

How many raw data records are read during each iteration of the DATA step?

NEW QUESTION 94
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?

NEW QUESTION 95
The following SAS program is submitted:
proc contents data = sasuser.airplanes;
run;
Which one of the following is produced as output?

NEW QUESTION 96
The following SAS program is submitted:
data WORK.OUTDS;
do until(Prod GT 6);
Prod + 1;
end;
run;
What is the value of the variable Prod in the output data set?

NEW QUESTION 97
The following program is submitted:
proc sort data=SASUSER.PROJECTS out=PSORT;
by Code descending Date Cost;
run;
Which of the following is true concerning the submitted program?

NEW QUESTION 98
Given the SAS data set WORK.ORDERS:

The variable Order_id is numeric; Customer is character; and Ship_date is a numeric containing a SAS date value.
A programmer would like to create a new variable called Note, that shows a character value with the Order_id and Ship_date shown with a date9. format. For the first observation, Note would look like the following: “Order 9341 shipped on 02FEB2009”.
Which of the following statement will correctly create the value and assign it to Note?

NEW QUESTION 99
Given the SAS data set EMPLOYEES:
EMPLOYEES
NAME SALARY
——– ————
Innis60000
Jolli50000
Ellis55000
Liu45000
The following SAS program is submitted:
proc print data = employees; where name like ‘_i%’;
run;
What is contained in the output?

NEW QUESTION 100
Which statement describes a characteristic of the SAS automatic variable _ERROR_?

NEW QUESTION 101
The following program is submitted:
proc contents data=_all_;
Which statement best describes the output from the submitted program?

NEW QUESTION 102
The following program is submitted:
proc contents data=_all_;
run;
Which statement best describes the output from the submitted program?

NEW QUESTION 103
This question will ask you to provide a line of missing code.
The following SAS program is submitted:
proc freq data = WORK.SALES;
<insert code here>
run;
The following output is created by the FREQUENCY procedure:

Which statement was used to complete the above program that produced the output?

NEW QUESTION 104
The following SAS program is submitted:
data _null_;
set old (keep = prod sales1 sales2);
file ‘file-specification’;
put sales1 sales2;
run;
Which one of the following default delimiters separates the fields in the raw data file created?

NEW QUESTION 105
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?

NEW QUESTION 106
The following SAS program is submitted:

What new value would be assigned to X if its original value was a missing value?

NEW QUESTION 107
The following SAS program is submitted:
data work.test;
First = ‘Ipswich, England’;
City = substr(First,1,7);
City_Country = City!!’, ‘!!’England’;
run;
Which one of the following is the value of the variable CITY_COUNTRY in the output data set?

NEW QUESTION 108
The following SAS program is submitted:
data WORK.PRODUCTS;
Prod=1;
do while (Prod LE 7);
Prod + 1;
end;
run;
What is the value of the variable Prod in the output data set?

NEW QUESTION 109
The following SAS program is submitted:
data WORK.DATE_INFO;
Day=”01″ ;
Yr=1960 ;
X=mdy(Day,01,Yr) ;
run;
What is the value of the variable X?

NEW QUESTION 110
The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:

The following SAS program is submitted:
proc print data=WORK.ONE;
where Num=contains (1);
run;
Which output is generated?

NEW QUESTION 111
The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of “Asking Price”.
Which SAS program temporarily replaces the label “Asking Price” with the label “Sale Price” in the output?

NEW QUESTION 112
The contents of the raw data file AMOUNT are listed below:
——–10——-20——-30
$1,234
The following SAS program is submitted:
data test;
infile ‘amount’;
input @1 salary 6.;
if _error_ then description = ‘Problems’;
else description = ‘No Problems’;
run;
Which one of the following is the value of the DESCRIPTION variable?

NEW QUESTION 113
On which portion(s) of a SAS data set does the PRINT procedure report?

NEW QUESTION 114
When SAS encounters a data when reading from a raw data file, which action will occur?

NEW QUESTION 115
The following SAS program is submitted:
data stats;
set revenue;
array weekly{5} mon tue wed thu fri;
total = weekly{i} * .25;
output;
end;
run;
Which one of the following DO statements completes the program and processes the elements of the WEEKLY array?

NEW QUESTION 116
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?