A00-211無料問題集「SASInstitute SAS Base Programming for SAS 9」

質問 1

The following SAS program is submitted:

Which statement is true about the output data set?

（A）The type of the variable CharEmpid is numeric.

（B）The type of the variable CharEmpid is unknown.

（C）The type of the variable CharEmpid is character.

（D）The program fails to execute due to errors.

正解：D 解答を投票する

質問 2

Given the SAS data set WORK.ONE:

What value will SAS assign to Total?

（A）4.8

（B）3

（C）1.6

（D）The program fails to execute due to errors.

正解：C 解答を投票する

質問 3

Given the following raw data records in TEXTFILE.TXT:

The following output is desired:

Which SAS program correctly produces the desired output?

（A）Option D

（B）Option B

（C）Option C

（D）Option A

正解：C 解答を投票する

質問 4

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 PRINT5000 for PROC MEANS

（B）401 for PROC PRINT4501 for PROC MEANS

（C）400 for PROC PRINT4500 for PROC MEANS

（D）401 for PROC PRINT4500 for PROC MEANS

正解：B 解答を投票する

質問 5

The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.; The following SAS program is submitted:

What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?

（A）The data step fails execution; there is no format for LocalFee.

（B）Both LocalFee and CountryFee have a format of percent7.2

（C）LocalFee has format of 9. and CountryFee has a format of 7.

（D）LocalFee has format of 9. and CountryFee has a format of percent7.2

正解：B 解答を投票する

質問 6

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）1

（B）15

（C）200

（D）6

正解：C 解答を投票する

質問 7

The following SAS program is submitted:
libname sasdata 'SAS-data-library';
data test;
set sasdata.chemists;
if jobcode = 'chem3'
then description = 'Senior Chemist';
else description = 'Unknown';
run;
A value for the variable JOBCODE is listed below:
JOBCODE
CHEM3
Which one of the following values does the variable DESCRIPTION contain?

（A）' ' (missing character value)

（B）Unknown

（C）chem3

（D）Senior Chemist

正解：B 解答を投票する

質問 8

This question will ask you to provide a line of missing code:
Given the SAS data set WORK.EMPLOYEE_UNFO:

The following SAS program is submitted:

In the space above, write the statement that will sort the data by ascending Expenses values within each ascending IDNumber value.

正解：

See explanation below.
Explanation
by IDNumber Expenses;
IDNumber Expenses
2542 100.00
3612 133.15
2198 234.34
2198 111.12

質問 9

The following SAS program is submitted:
proc sort data=SASUSER.PROJECTS out=PSORT;
by Product Code descending Date Cost;
run;
Which of the following is true concerning the submitted program?

（A）The descending option applies to the Date and Cost variables.

（B）The descending option applies only to the Date variable.

（C）The descending option applies to the Product and Code variables.

（D）The descending option applies only to the Code variable.

正解：A 解答を投票する

質問 10

Consider the following data step:
data WORK.NEW;
set WORK.OLD;
Count+1;
run;
The varaible Count is created using a sum statement. Which statement regarding this variable is true?

（A）It is assigned a value 0 when the data step begins execution.

（B）It is assigned a value of missing when the data step begins execution.

（C）It is assigned a value of missing at compile time.

（D）It is assigned a value 0 at compile time.

正解：D 解答を投票する

質問 11

Which step sorts the observations of a permanent SAS data set by two variables and stores the sorted observations in a temporary SAS data set?

（A）proc sort out=EMPLOYEES data=EMPSORT;by Lname and Fname;run;

（B）proc sort data=SASUSER.EMPLOYEES out=EMPSORT;by Lname Fname;run;

（C）proc sort data=SASUSER.EMPLOYEES out=SASUSER.EMPSORT;by Lname and Fname;run;

（D）proc sort out=SASUSER.EMPLOYEES data=WORK.EMPSORT;by Lname Fname;run;

正解：B 解答を投票する

質問 12

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?

（A）72

（B）2

（C）95

（D）. (missing numeric value)

正解：B 解答を投票する

質問 13

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）01012000

（B）The value can not be determined as the program fails to execute due to errors

（C）. (missing numeric value)

（D）January 1st

正解：B 解答を投票する

質問 14

The following SAS program is submitted:
data test;
set chemists;
jobcode = 'Chem2'
then description = 'Senior Chemist';
else description = 'Unknown';
run;
The value for the variable JOBCODE is:
JOBCODE
-------------
chem2
What is the value of the variable DESCRIPTION?

（A）chem2

（B）' ' (missing character value)

（C）Unknown

（D）Senior Chemist

正解：C 解答を投票する

質問 15

The SAS data set named WORK.TEST is listed below:
capacity airplanetype staff
150 Large 10
Which one of the following SAS programs created this data set?

（A）data work.test;capacity = 150;if 100 le capacity le 200 thenairplanetype = 'Large' and staff = 10;else airplanetype = 'Small' and staff = 5;run;

（B）data work.test;capacity = 150;if 100 le capacity le 200 then;airplanetype = 'Small';staff =
5;else;airplanetype = 'Large';staff = 10;run;

（C）data work.test;capacity = 150;if 100 le capacity le 200 thendo;airplanetype = 'Large';staff =
10;elsedo;airplanetype = 'Small';staff = 5;end;run;

（D）data work.test;capacity = 150;if 100 le capacity le 200 thendo;airplanetype = 'Large';staff =
10;end;elsedo;airplanetype = 'Small';staff = 5;end;run;

正解：D 解答を投票する

質問 16

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?

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

（B）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.

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

（D）City's value will be assigned one time, State's value 5 times.

正解：D 解答を投票する

質問 17

The following SAS program is submitted:
data work.staff;
JobCategory = 'FA';
JobLevel = '1';
JobCategory = JobCategory || JobLevel;
run;
Which one of the following is the value of the variable JOBCATEGORY in the output data set?

（A）' ' (missing character value)

（B）FA

（C）FA1

（D）FA 1

正解：B 解答を投票する

質問 18

Which one of the following is true of the SUM statement in a SAS DATA step program?

（A）It is not valid with the SET, MERGE and UPDATE statements.

（B）It does not retain the accumulator variable value from one iteration of the SAS DATA step to the next.

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

（D）It is only valid in conjunction with a SUM function.

正解：C 解答を投票する

A00-211 無料問題集「SASInstitute SAS Base Programming for SAS 9」

弊社を連絡する

関連リンク

トップ試験