SASInstitute SAS base programming - A00-201 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

The contents of the raw data file CALENDAR are listed below:
----|----10---|----20---|----30
01012000
The following SAS program is submitted:
data test;
infile 'calendar';
input @1 date mmddyy10.;
if date = '01012000'd then event = 'January 1st';
run;
Which one of the following is the value of the EVENT variable?

A. . (missing numeric value) B. The value can not be determined as the program fails to execute due to errors. C. January 1st D. 01012000

Discussion 0

Correct Answer: B Vote an answer

Question 2

Which one of the following SAS statements renames two variables?

A. set work.dept1
work.dept2(rename = (jcode = jobcode
sal = salary)); B. set work.dept1
work.dept2(rename = jcode = jobcode
sal = salary); C. set work.dept1
work.dept2(rename = (jcode jobcode)
(sal salary)); D. set work.dept1
work.dept2(rename = (jcode = jobcode)
(sal = salary));

Discussion 0

Correct Answer: A Vote an answer

Question 3

Which one of the following statements is true regarding the name of a SAS array?

A. It is saved with the data set. B. It can be used in procedures. C. It exists only for the duration of the DATA step. D. It can be the same as the name of a variable in the data set.

Discussion 0

Correct Answer: C Vote an answer

Question 4

The observations in the SAS data set WORK.TEST are ordered by the values of the variable SALARY.
The following SAS program is submitted:
proc sort data = work.test out = work.testsorted;
by name;
run;
Which one of the following is the result of the SAS program?

A. The data set WORK.TESTSORTED is stored in ascending order by values of the NAME variable. B. The data set WORK.TEST is stored in descending order by values of the NAME variable. C. The data set WORK.TESTSORTED is stored in descending order by values of the NAME variable. D. The data set WORK.TEST is stored in ascending order by values of the NAME variable.

Discussion 0

Correct Answer: A Vote an answer

Question 5

A realtor has two customers. One customer wants to view a list of homes selling for less than $60,000. The other customer wants to view a list of homes selling for greater than
$100,000.
Assuming the PRICE variable is numeric, which one of the following PRINT procedure steps will select all desired observations?

A. proc print data = sasuser.houses;
where price lt 60000 and price gt 100000;
run; B. proc print data = sasuser.houses;
where price lt 60000;
where price gt 100000;
run; C. proc print data = sasuser.houses;
where price lt 60000 or where price gt 100000;
run; D. proc print data = sasuser.houses;
where price lt 60000 or price gt 100000;
run;

Discussion 0

Correct Answer: D Vote an answer

Question 6

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. 6 B. 2 C. 1 D. 5

Discussion 0

Correct Answer: A Vote an answer