SASInstitute SAS Base Programming for SAS 9 - A00-211 Exam Practice Test
Given the SAS data set WORK.ORDERS:
Ship_date is a numeric variable containing a SAS data value. A programmer would like to create a new character variable Ship_date-char that represents the ship date as a character string, such as "February 2,2009' Which statement will create the new variable Ship_date_char as a character value with a format such as
"February 2, 2009"?
Ship_date is a numeric variable containing a SAS data value. A programmer would like to create a new character variable Ship_date-char that represents the ship date as a character string, such as "February 2,2009' Which statement will create the new variable Ship_date_char as a character value with a format such as
"February 2, 2009"?
Correct Answer: D
Vote an answer
Given the SAS data set WORK.P2000:
And the SAS data set WORK.P2008:
The following output is desired:
Which SAS program correctly combines the data?
And the SAS data set WORK.P2008:
The following output is desired:
Which SAS program correctly combines the data?
Correct Answer: D
Vote an answer
The following SAS program is submitted;
data combine;
country = 'Italy, Russia, ireland';
found = find(country, 'i');
run;
What is the value of the variable FOUND in the output data set?
data combine;
country = 'Italy, Russia, ireland';
found = find(country, 'i');
run;
What is the value of the variable FOUND in the output data set?
Correct Answer: A
Vote an answer
The following SAS program is submitted:
What types of variables are DayOfMonth, MonthOfYear, and Year?
What types of variables are DayOfMonth, MonthOfYear, and Year?
Correct Answer: A
Vote an answer
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?
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?
Correct Answer: C
Vote an answer
The following SAS program is submitted:
data test;
set sasuser.employees;
if 2 le years_service le 10 then
amount = 1000;
else amount = 0;
amount_per_year = years_service / amount
run;
What is the value of the variable AMOUNT_PER_YEAR if an employee has been with the company for one year?
data test;
set sasuser.employees;
if 2 le years_service le 10 then
amount = 1000;
else amount = 0;
amount_per_year = years_service / amount
run;
What is the value of the variable AMOUNT_PER_YEAR if an employee has been with the company for one year?
Correct Answer: D
Vote an answer
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?
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?
Correct Answer: A
Vote an answer
Which one of the following statements is true regarding the name of a SAS array?
Correct Answer: A
Vote an answer
A SAS programmer assigns a library reference to an existing Excel workbook named exceldata.xlsx. Using a DATA step, the programmer attempts to create a worksheet named outdata in this Excel workbook. However, the Excel workbook already contains a worksheet named outdata.
What will happen?
What will happen?
Correct Answer: C
Vote an answer
The following SAS program is submitted:
<_insert_ods_code_>
proc means data=SASUSER.SHOES;
where Product in ('Sandal' , 'Slipper' , 'Boot');
run;
<_insert_ods_code_>
Which ODS statements inserted, respectively, in the two location above creates a report stored in an html file?
<_insert_ods_code_>
proc means data=SASUSER.SHOES;
where Product in ('Sandal' , 'Slipper' , 'Boot');
run;
<_insert_ods_code_>
Which ODS statements inserted, respectively, in the two location above creates a report stored in an html file?
Correct Answer: D
Vote an answer