A00-231試験無料問題集（298題）「SASInstitute SAS 9.4 Base Programming

出題：1

The following SAS program is submitted:

Which statement is true about the output data set?

A. The type of the variable CharEmpid is character.

B. The type of the variable CharEmpid is unknown.

C. The program fails to execute due to errors.

D. The type of the variable CharEmpid is numeric.

正解：C 解答を投票する

出題：2

The following SAS program is submitted:
data work.pieces;
do while (n lt 6);
n + 1;
end;
run;
Which one of the following is the value of the variable N in the output data set?

A. 4

B. 6

C. 5

D. 7

正解：B 解答を投票する

出題：3

Which statement correctly computes the average of four numerical values?

A. average = mean(ofnum1 - num4)

B. average = mean(num1, num4);

C. average = mean(num1 num2 num3 num4);

D. average = mean(num1 - num4);

正解：A 解答を投票する

出題：4

The contents of the raw data file FURNITURE are listed below:
--------10-------20-------30
chair,,table
chair,couch,table
The following SAS program is submitted:
data stock;
infile 'furniture' dsd;
input item1 $ item2 $ item3 $;
run;
Which one of the following is the value of the variable named ITEM2 in the first observation of the output data set?

A. ,table

B. '' (missing character value)

C. . (missing numeric value)

D. table

正解：B 解答を投票する

出題：5

The following SAS program is submitted:
data work.company;
set work.dept1(keep = jobcode)
work.dept2(rename = (jcode = jobcode));
run;
Which one of the following is the result?

A. Neither variable JCODE nor JOBCODE is written to the output data set.

B. The variable JCODE is written to the output data set.

C. The variable JOBCODE is written to the output data set.

D. The program fails to execute due to errors.

正解：C 解答を投票する

出題：6

After a SAS program is submitted, the following is written to the SAS log:

What changes should be made to the KEEP statement to correct the errors in the LOG?

A. keep Product Sales;

B. keep Product, Sales;

C. keep=Product, Sales;

D. keep=(Product Sales);

正解：A 解答を投票する

出題：7

The following SAS program is submitted:
data WORK.ACCOUNTING;
set WORK.DEPARTMENT;
length EmpId $6;
CharEmpid=EmpId;
run;
If data set WORK.DEPARTMENT has a numeric variable EmpId.
Which statement is true about the output dataset?

A. The type of the variable CharEmpid is character.

B. The type of the variable CharEmpid is unknown.

C. The program fails to execute due to errors.

D. The type of the variable CharEmpid is numeric.

正解：C 解答を投票する

出題：8

Assume that Sasuser.One does not exist and that the following SAS program is submitted at the beginning of a new SAS session:
data sasuser.one;
x=1;
y=27;
output one; run;
Select one:

A. The data set Sasuser.One is created with 2 variables and 0 observations.

B. The data set Work.One is created with 2 variables and 1 observation.

C. The data set Sasuser.One is created with 2 variables and 3 observations.

D. The data set Sasuser.One is created with 2 variables and 1 observation.

正解：A 解答を投票する

出題：9

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;

正解：A 解答を投票する

出題：10

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

正解：B 解答を投票する

出題：11

CORRECT TEXT
The following SAS program is submitted:

What value will SAS assign to Pos? Enter your numeric answer in the space below.

正解：

12

出題：12

Given the SAS data set WORK.PRODUCTS:

How many observations does the WORK.OUTDOOR data set contain?

A. 2

B. 1

C. 6

D. 3

正解：A 解答を投票する

出題：13

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. FA1

C. FA

D. FA 1

正解：C 解答を投票する

出題：14

Given the following raw data records:

The following output is desired:

Which SAS program correctly reads in the raw data?

A. Option D

B. Option C

C. Option A

D. Option B

正解：A 解答を投票する

出題：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 then;airplanetype = 'Small';staff = 5;else;airplanetype = 'Large';staff = 10;run;

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

C. data work.test;capacity = 150;if 100 le capacity le 200 thenairplanetype = 'Large' and staff = 10;else airplanetype = 'Small' and staff = 5;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

Given the raw data file EMPLOYEE:
----I----1 0---I----20---I----30
Ruth 39 11
Jose 32 22
Sue 30 33
John 40 44
The following SAS program is submitted:
data test;
infile 'employee';
input employee_name $ 1-4;
if employee_name = 'Ruth' then input idnum 10-11;
else input age 7-8;
run;
What value does the variable IDNUM contain when the name of the employee is "Ruth"?

A. 11

B. (missing numeric value)

C. 33

D. 22

正解：D 解答を投票する

出題：17

Given the SAS data set EMPLOYEE INFO:
EMPLOYEE_INFO
IDNumber
Expenses
2542
100.00
3612
133.15
2198
234.34
2198
111.12
The following SAS program is submitted:
proc sort data = employee_info;
<insert BY statement here>
run;
Which BY statement completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?

A. by Expenses IDNumber;

B. by ascending Expenses IDNumber;

C. by IDNumber Expenses;

D. by ascending IDNumber ascending Expenses;

正解：C 解答を投票する

出題：18

The following SAS program is submitted:
data work.one;
x = 3;
y = 2;
z = x ** y;
run;
Which one of the following is the value of the variable Z in the output data set?

A. . (missing numeric value)

B. 9

C. 6

D. The program fails to execute due to errors.

正解：B 解答を投票する

出題：19

Given the following code:
proc print data=SASHELP.CLASS(firstobs=5 obs=15);
where Sex='M';
run;
How many observations will be displayed?

A. 10 or fewer

B. 11

C. 11 or fewer

D. 15

正解：C 解答を投票する

出題：20

A raw data file is listed below:

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

A. No data set is created as the program fails to execute due to errors.

B. 2

C. 0

D. 3

正解：D 解答を投票する

A00-231試験無料問題集「SASInstitute SAS 9.4 Base Programming - Performance-based 認定」