2022 A00-211 dumps review - Professional Quiz Study Materials
A00-211 Test Prep Training Practice Exam Questions Practice Tests
NEW QUESTION 46
The following SAS program is submitted:
data work.test;
Author = 'Agatha Christie';
First = substr(scan(author,1,' ,'),1,1);
run;
Which one of the following is the length of the variable FIRST in the output data set?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
Section: Volume B
NEW QUESTION 47
Given the SAS data set WORK.TEMPS with numeric variables Day and Temp and character variable
Month:
The following SAS program is submitted:
proc sort data=WORK.TEMPS;
by Day descending Month;
run;
proc print data=WORK.TEMPS;
run;
Which output is correct?
A:
B:
C:
D:
- A. Option C
- B. Option B
- C. Option A
- D. Option D
Answer: B
NEW QUESTION 48
The following SAS program is submitted:
options pageno = 1;
proc print data = sasuser.houses;
run;
proc means data = sasuser.shoes;
run;
The report created by the PRINT procedure step generates 5 pages of output.
What is the page number on the first page of the report generated by the MEANS procedure step?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION 49
The following SAS program is submitted:
proc sort data = work.employee;
by descending fname;
proc sort data = work.salary;
by descending fname;
data work.empdata;
merge work.employee
work.salary;
by fname;
run;
Why does the program rail to execute?
- A. The SORT procedures contain invalid syntax.
- B. The RUN statement was omitted alter each or the SORT procedures.
- C. The merged data sets are not permanent SAS data sets.
- D. The data sets were not merged in the order by which they were sorted.
Answer: D
NEW QUESTION 50
The following SAS program is submitted:
Which statement is true about the output data set?
- A. The label of the variable Jobcode is Job Description.
- B. Labels can only be defined in PROC steps. The program fails to execute due to errors and the data set is not created.
- C. The label of the variable Jobcode is Job Desc.
- D. The label of the variable Jobcode is Job.
Answer: A
NEW QUESTION 51
The following SAS program is submitted:
What is the value of the variable Prod in the output data set?
- A. 0
- B. 1
- C. 2
- D. . (missing numeric)
Answer: B
NEW QUESTION 52
When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:
libname sasdata 'SAS-data-library';
options obs = 500;
proc print data = sasdata.prdsales (firstobs = 100);
run;
options obs = max;
proc means data = sasdata.prdsales (firstobs = 500);
run;
How many observations are processed by each procedure?
- A. 500 for PROC PRINT
5000 for PROC MEANS - B. 401 for PROC PRINT
4501 for PROC MEANS - C. 401 for PROC PRINT
4500 for PROC MEANS - D. 400 for PROC PRINT
4500 for PROC MEANS
Answer: B
Explanation:
Section: Volume B
NEW QUESTION 53
Given the SAS data set WORK.ONE:
And the SAS data set WORK.TWO: The following program is submitted:
What is the first observation in the SAS data set WORK.BOTH?
- A. Option B
- B. Option C
- C. Option D
- D. Option A
Answer: D
NEW QUESTION 54
The following SAS program is submitted:
proc contents data=_all_;
run;
Which statement best describes the output from the submitted program?
- A. The output displays a list of the SAS data sets that are contained in the WORK library and displays their metadata.
- B. The output displays only the variables in the SAS data sets that are contained in the WORK library.
- C. The output displays only the metadata of the SAS data sets that are contained in the WORK library.
- D. The output displays only a list of the SAS data sets that are contained in the WORK library.
Answer: A
NEW QUESTION 55
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?
- A. Innis and Ellis only
- B. Innis, Ellis, and Liu only
- C. Innis, Jolli, Ellis, and Liu
- D. Liu only
Answer: D
NEW QUESTION 56
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?
- A. Num Char
--- ----
1 23
3 23
1 77 - B. Num Char
--- ----
1 23
1 77 - C. No output is generated.
- D. Num Char
--- ----
1 23
Answer: C
Explanation:
Section: Volume A
NEW QUESTION 57
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?
- A. note=catx(' ','Order',order_id,'shipped on',input(ship_date,date9.));
- B. note=catx(' ','Order',order_id,'shipped on',put(ship_date,date9.));
- C. note=catx(' ','Order',order_id,'shipped on',transwrd(ship_date,date9.));
- D. note=catx(' ','Order',order_id,'shipped on',char(ship_date,date9.));
Answer: B
Explanation:
Section: Volume B
NEW QUESTION 58
The following SAS program is submitted:
data work.month; date = put('13mar2000'd,ddmmyy10.); run;
Which one of the following represents the type and length of the variable DATE in the output data set?
- A. character, 8 bytes
- B. numeric, 10 bytes
- C. numeric, 8 bytes
- D. character, 10 bytes
Answer: D
NEW QUESTION 59
The following SAS program is submitted:
How many observations are written to the WORK.SALES data set?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
NEW QUESTION 60
The following SAS program is submitted:
proc contents data = sasuser.airplanes;
run;
Which one of the following is produced as output?
- A. the data portion of the data set SASUSER.AIRPLANES only
- B. the data portion of every data set in the SASUSER library
- C. the descriptor portion of the data set SASUSER.AIRPLANES only
- D. the descriptor portion of every data set in the SASUSER library
Answer: C
NEW QUESTION 61
The following SAS program is submitted:
data work.accounting;
set work.department;
length jobcode $ 12;
jobcode='FAl';
run;
The WORK.DEPARTMENT data set contains a character variable named JOBCODE with a length of 5. What is the result?
- A. The length of the variable JOBCODE is 5.
- B. The length of the variable JOSBODE is 12.
- C. The program fails to execute due to errors.
- D. The length of the variable JOBCODE is 3.
Answer: A
Explanation:
Section: Volume A
NEW QUESTION 62
Given the following code:
proc print data=SASHELP.CLASS(firstobs=5 obs=15);
where Sex='M';
run;
How many observations will be displayed?
- A. 0
- B. 1
- C. 10 or fewer
- D. 11 or fewer
Answer: D
NEW QUESTION 63
......
Exam Questions Answers Braindumps A00-211 Exam Dumps PDF Questions: https://www.actualtorrent.com/A00-211-questions-answers.html