Certbus > SASInstitute > SAS Institute Systems Certification > A00-211 > A00-211 Online Practice Questions and Answers

A00-211 Online Practice Questions and Answers

Questions 4

The following SAS program is submitted:

data work.empsalary;

set work.people (in = inemp)

work.money (in = insal);

if insal and inemp;

run;

The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7

observations. How many observations will the data set WORK.EMPSALARY contain?

A. 0

B. 5

C. 7

D. 12

Browse 270 Q&As
Questions 5

The following SAS program is submitted:

data test;

infile `file specification';

input name $ amount@@;

run;

Which of the following is true?

A. Two @@ together are the same as one c.

B. Two @@ hold the data records until the bottom of the DATA step.

C. Two @@ hold the raw data record across iterations of the DATA step.

D. Two @@ are invalid syntax and will cause the program to fail to execute.

Browse 270 Q&As
Questions 6

The following SAS program is submitted:

data combine; prefix='505'; middle='6465 `; end='09090'; ; run;

Which statement successfully completes the program so that TOTAL has a value of 505-6465-09090?

A. total = cat('-', prefix, middle, end);

B. total = catx('-', prefix, middle, end);

C. total = prefix !!'-'!! middle ``!!'-'!! end;

D. total = prefix!!'-'!! left(middle)!!'-'!! end;

Browse 270 Q&As
Questions 7

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?

A. FullName=CATX(' ',EmpFName,EmpLName);

B. FullName=CAT(' ',EmpFName,EmpLName);

C. FullName=EmpFName!!EmpLName;

D. FullName=EmpFName + EmpLName;

Browse 270 Q&As
Questions 8

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?

A. 2 temporary and 1 permanent SAS data sets are created

B. 3 temporary and 2 permanent SAS data sets are created

C. 2 temporary and 2 permanent SAS data sets are created

D. there is an error and no new data sets are created

Browse 270 Q&As
Questions 9

The following output is created by the FREQUENCY procedure:

Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?

A. norowcount nocolcount

B. freq percent

C. norow nocol D. nocounts

Browse 270 Q&As
Questions 10

The following SAS program is submitted:

What is produced as output?

A. A file named test.cvs that can only be opened in Excel.

B. A text file named test.cvs that can be opened in Excel or in any text editor.

C. A text file named test.cvs that can only be opened in a text editor.

D. A file named test.cvs that can only be opened by SAS.

Browse 270 Q&As
Questions 11

The SAS data set Fed.Banks contains a variable Open_Date which has been assigned a permanent label

of "Open Date".

Which SAS program temporarily replaces the label "Open Date" with the label "Starting Date" in the

output?

A. proc print data=SASUSER.HOUSES label; label Open_Date "Starting Date"; run;

B. proc print data=SASUSER.HOUSES label; label Open_Date="Starting Date"; run;

C. proc print data=SASUSER.HOUSES; label Open_Date="Starting Date"; run;

D. proc print data=SASUSER.HOUSES; Open_Date="Starting Date"; run;

Browse 270 Q&As
Questions 12

Consider the data step: Which of the following assignment statements for variable group are functionally equivalent to the original statement used in the above data step?

A. if Age not in(15,16) then Group=1; else Group=2;

B. if (Age NE 16) or (Age NE 15) then Group=1; else Group=2;

C. where Age not between 15 and 16 then Group=1; else Group=2;

D. both A or C will work.

Browse 270 Q&As
Questions 13

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

A. TIME

B. DATE

C. TODAY

D. DATETIME

Browse 270 Q&As
Questions 14

The following SAS program is submitted:

data work.new;

length word $7;

amount = 7;

if amount = 5 then word = 'CAT';

else if amount = 7 then word = 'DOG';

else word = 'NONE!!!';

amount = 5;

run;

Which one of the following represents the values of the AMOUNT and WORD variables?

A. amount word 5 DOG

B. amount word 5 CAT

C. amount word 7 DOG

D. amount word 7 ' ' (missing character value)

Browse 270 Q&As
Questions 15

The following SAS program is submitted:

data work.test;

Author = 'Christie, Agatha';

First = substr(scan(author,2,' ,'),1,1);

run;

Which one of the following is the value of the variable FIRST in the output data set?

A. A

B. C

C. Agatha

D. ' ' (missing character value)

Browse 270 Q&As
Questions 16

The following SAS DATA step is submitted:

libname temp 'SAS-data-library';

data temp.report;

set sasuser.houses;

newvar = price * 1.04;

run;

Which one of the following statements is true regarding the program above?

A. The program is reading from a temporary data set and writing to a temporary data set.

B. The program is reading from a temporary data set and writing to a permanent data set.

C. The program is reading from a permanent data set and writing to a temporary data set.

D. The program is reading from a permanent data set and writing to a permanent data set.

Browse 270 Q&As
Questions 17

Given the following raw data records:

The following output data set is desired:

Which SAS program correctly reads in the raw data?

A. B. C. D.

Browse 270 Q&As
Questions 18

Given the data set WORK.DEPARTMENTS:

The following SAS program is submitted: Which output will be generated?

A. B. C. D.

Browse 270 Q&As
Exam Code: A00-211
Exam Name: SAS Base Programming for SAS 9
Last Update: Mar 21, 2024
Questions: 270 Q&As

PDF

$45.99

VCE

$49.99

PDF + VCE

$59.99