Get all the Information About SASInstitute A00-211 Exam 2022 Practice Test Questions [Q110-Q124]

13Oct 2022 by admin No Comments

4/5 - (1 vote)

Get all the Information About SASInstitute A00-211 Exam 2022 Practice Test Questions

Check Real SASInstitute A00-211 Exam Question for Free (2022)

Who should take the A00-211 : SAS Certified Base Programmer for SAS 9 Exam

Individuals should pursue the A00-211 Exam if they want to demonstrate their expertise and ability to access and manage data to perform queries and analyses from A00-211 : SAS Certified Base Programmer for SAS 9 Certification

Programmers
Analysts
Data managers
Or anyone writing & interested in SAS programs

Q110. Which one of the following is true of the RETAIN statement in a SAS DATA step program?

It can be used to assign an initial value to _N_ .

It is only valid in conjunction with a SUM function.

It has no effect on variables read with the SET, MERGE and UPDATE statements.

It adds the value of an expression to an accumulator variable and ignores missing values.

Q111. The following SAS program is submitted:
libname company ‘SAS-data-library’;
proc sort data = company.payroll;
by EmployeeIDNumber;
run;
Write access has been granted to the COMPANY library.
Which one of the following represents how the observations are sorted?

COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber.

COMPANY.PAYROLL is stored in original order, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber.

COMPANY.PAYROLL is stored in original order, and a new data set
COMPANY.PAYROLLSORTED is created in sorted order by EmployeeIDNumber.

COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber

Q112. The contents of the raw data file SIZE are listed below:
——–10——-20——-30
72 95
The following SAS program is submitted:
data test;
infile ‘size’;
input @1 height 2. @4 weight 2;
run;
Which one of the following is the value of the variable WEIGHT in the output data set?

. (missing numeric value)

Section: Volume B

Q113. Given the following raw data record:
07Jan20 05
Which INFOFRMAT reads this raw data and stores it as a SAS date value?

dmy9.

date9.

ddMMMyy9.

ddmmmyyyy9.

Q114. The following SAS program is submitted:

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

X would get a value of 1.

X would get a value of 3.

X would retain its original value of missing.

This step does not run because of syntax errors.

Q115. The following SAS program is submitted, creating the SAS data set ONE:
data one;
infile ‘file specification’;
input num chars$;
run;
ONE
NUMCHAR
123 323 177
The following SAS program is submitted:
proc print data = one; where char = 23; run;
What is output?

NUM CHAR 1 77 2

NUM CHAR 1 23 3 23

NUM CHAR 1 23 3 23 1 77

No output is generated.

Q116. Consider the following data step:

The computed variables City and State have their values assigned using two different methods, a RETAIN statement and an Assignment statement. Which statement regarding this program is true?

The RETAIN statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted.

Both the RETAIN and assignment statement are being used to initialize new variables and are equally efficient. Method used is a matter of programmer preference.

The assignment statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted.

City’s value will be assigned one time, State’s value 5 times.

Section: Volume B

Q117. The following SAS program is submitted:
proc contents data=_all_;
run;
Which statement best describes the output from the submitted program?

The output displays only a list of the SAS data sets that are contained in the WORK library.

The output displays a list of the SAS data sets that are contained in the WORK library and displays their metadata.

The output displays only the variables in the SAS data sets that are contained in the WORK library.

The output displays only the metadata of the SAS data sets that are contained in the WORK library.

Section: Volume B

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

The output contains only a list of the SAS data sets that are contained in the WORK library.

The output displays only the contents of the SAS data sets that are contained in the WORK library.

The output displays only the variables in the SAS data sets that are contained in the WORK library.

The output contains a list of the SAS data sets that are contained in the WORK library and displays the
contents of those data sets.

Q119. The following SAS program is submitted:

What will the data set WORK.TEST contain?

Option A

Option B

Option C

Option D

Q120. Consider the following data step:

The computed variables City and State have their values assigned using two different methods, a
RETAIN statement and an Assignment statement. Which statement regarding this program is true?

The RETAIN statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted.

Both the RETAIN and assignment statement are being used to initialize new variables and are equally efficient. Method used is a matter of programmer preference.

The assignment statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted.

City’s value will be assigned one time, State’s value 5 times.

Q121. Given the following raw data records:

The following output data set is desired:

Which SAS program correctly reads in the raw data?

Section: Volume B

Q122. The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by Department. The following SAS program is submitted:

Which statement is true?

The by statement in the DATA step causes a syntax error.

The statement Payroll+(MonthlyWageRate*12); in the data step causes a syntax error.

The values of the variable Payroll represent the monthly total for each department in the WORK.SALARY data set.

The values of the variable Payroll represent a monthly total for all values of WAGERATE in the WORK.SALARY data set.

Q123. The following SAS program is submittad:
data work.sales;
do year = 1 to 5;
do month=1 to 12;
x+1;
output
end;
end;
run;
How many observations are written the WORK SALES data set?

Q124. A raw data record is listed below:
——–10——-20——-30
1999/10/25
The following SAS program is submitted:
data projectduration;
infile ‘file-specification’;
input date $ 1 – 10;
run;
Which one of the following statements completes the program above and computes the duration of the project in days as of today’s date?

duration = today( ) – put(date,ddmmyy10.);

duration = today( ) – put(date,yymmdd10.);

duration = today( ) – input(date,ddmmyy10.);

duration = today( ) – input(date,yymmdd10.);

Loading …