A00-231無料問題集「SASInstitute SAS 9.4 Base Programming

質問 1

Which is a valid LIBNAME statement?

（A）libname sasdata sas "_SAS_data_library_location_";

（B）libname sasdata "_SAS_data_library_location_";

（C）libname "_SAS_data_library_location_";

（D）sasdata libname "_SAS_data_library_location_";

正解：B 解答を投票する

質問 2

A PROC PRINT report was created with the following title:
Asia Sports Vehicle Summary After the PROC PRINT report is run, a programmer would next like to produce a PROC FREQ report with the following title: Asia Sports Vehicle Summary Distribution by Make Which statement(s) would produce the new report titles?
Select one:

（A）title "Asia Sports Vehicle Summary"; title2 "Distribution by Make";

（B）title "Asia Sports Vehicle Summary"; subtitle "Distribution by Make";

（C）title "Asia Sports Vehicle Summary"; title "Distribution by Make";

（D）title "Distribution by Make";

正解：A 解答を投票する

質問 3

The following SAS program is submitted:
proc freq data = class;
tables gender * age / <insert option here>;
run;
The following report is created:
The FREQ Procedure
Table of gender by age
Row Column
Gender ageFrequencyPercent Percent Percent
F11110.0020.0050.00
12220.0040.0040.00
13220.0040.0066.67
Total550.00100.00
M11110.0020.0050.00
12330.0060.0060,00
13110.0020.0033.33
Total550.00100.00
Total11220.00100.00
12550.00100.00
13330.00100.00
Total10100.00
Which option correctly completes the program and creates the report?

（A）LIST

（B）CROSSLIST

（C）NOCOLS

（D）NOCROSSTAB

正解：B 解答を投票する

質問 4

Given the SAS data set EMPLOYEES:
EMPLOYEES
NAME SALARY
-------- ------------
Innis60000
Jolli50000
Ellis55000
Liu45000
The following SAS program is submitted:
proc print data = employees; where name like '_i%';
run;
What is contained in the output?

（A）Innis, Ellis, and Liu only

（B）Liu only

（C）Innis and Ellis only

（D）Innis, Jolli, Ellis, and Liu

正解：B 解答を投票する

質問 5

The contents of the raw data file AMOUNT are listed below:
--------10-------20-------30
$1,234
The following SAS program is submitted:
data test;
infile 'amount';
input @1 salary 6.;
if _error_ then description = 'Problems';
else description = 'No Problems';
run;
Which one of the following is the value of the DESCRIPTION variable?

（A）No Problems

（B）'' (missing character value)

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

（D）Problems

正解：D 解答を投票する

質問 6

Given the SAS data set SASDATA TWO:
SASDATA TWO
XY
52
31
56
The following SAS program is submitted:
data sasuser.one two sasdata.three;
set sasdata two;
if x = 5 then output sasuser.one;
else output sasdata two;
run;
What is the result?

（A）data set SASUSER.ONE has 2 observationsdata set SASUSER.TWO has 2 observationsdata set WORK.OTHER has 1 observations

（B）data set SASUSER.ONE has 2 observationsdata set SASUSER.TWO has 2 observationsdata set WORK.OTHER has 5 observations

（C）data set SASUSER.ONE has 5 observationsdata set SASUSER.TWO has 5 observationsdata set WORK.OTHER has 3 observations

（D）No data sets are output.The DATA step fails execution due to syntax errors.

正解：D 解答を投票する

質問 7

The following SAS program is submitted:
data numrecords;
infile 'file specification';
input@1 patient $15. relative$ 16-26@;
if relative = 'children' then
input @54 diagnosis $15. @;
else if relative = 'parents' then
input @28 doctor $15. clinic $ 44-53
@54 diagnosis $15. @;
input age;
run;
How many raw data records are read during each iteration of the DATA step execution?

（A）3

（B）1

（C）4

（D）2

正解：D 解答を投票する

質問 8

Which one of the following SAS procedures displays the data portion of a SAS data set?

（A）PRINT

（B）FSLIST

（C）CONTENTS

（D）DATASETS

正解：A 解答を投票する

質問 9

The following SAS program is submitted;
data combine;
country = 'Italy, Russia, ireland';
found = find(country, 'i');
run;
What is the value of the variable FOUND in the output data set?

（A）12

（B）1

（C）Russia

（D）Italy

正解：A 解答を投票する

質問 10

The following SAS program is submitted:
Data_null_;
set old;
put sales 1 sales2;
run;
Where is the output written?

（A）to the raw data file that was most recently opened

（B）to the SAS log

（C）to the SAS output window or to an output file

（D）to the SAS data set _NULL_

正解：B 解答を投票する

質問 11

Which of the following choices is an unacceptable ODS destination for producing output that can be viewed in Microsoft Excel?

（A）WINXP

（B）MSOFFICE2K

（C）CSVALL

（D）EXCELXP

正解：A 解答を投票する

質問 12

What is the purpose or the MISSOVER option on the INFILE statement?

（A）It enables SAS to scan the input data records until the character string that is specified in the @'character-string' expression is round.

（B）It enables SAS to continue to read the next input data record if it does not find values in the current input tine for all the variables in the statement.

（C）It prevents SAS from loading a new record when the end of the current record is reached.

（D）It causes the DATA step to stop processing if an INPUT statement reaches the end of the current record without finding values for all variables in the statement.

正解：C 解答を投票する

質問 13

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

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

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

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

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

正解：D 解答を投票する

質問 14

The following SAS program is submitted:
libname temp 'SAS data library';
data work.new;
set temp.jobs;
format newdate mmddw10.;
mdate = month(newdate);
ddate = weekday(newdate);
run;
proc print data = work.new; run;
The variable NEWDATE contains the SAS date value for April 15. 2005.
What output is produced if April 15, 2005 falls on a Friday?

（A）Obs newdate mdate ddate104/15/2005 4 7

（B）Obs newdate mdate ddate104/15/2005 4 6

（C）Obs newdate mdate ddate104/15/2005 APR 7

（D）Obsnewdate mdate ddate104/15/2005 APR 6

正解：B 解答を投票する

質問 15

Given the following raw data records:

The following output data set is desired:

Which SAS program correctly reads in the raw data?

（A）data employees; infile 'file specification'dlm='*'; input employee $ bdata: mmddyy10.years; run;

（B）data employees; infile 'file specification'dsd='*'; input employee $ bdata mmddyy10.years; run;

（C）data employees; infile 'file specification'DLM dsd; input employee $ bdata mmddyy10.years; run;

（D）data employees; infile 'file specification' dLM='*' dsd; input employee $ bdata: mmddyy10.years; run;

正解：D 解答を投票する

質問 16

Given the SAS data set WORKAWARDS:
WORK.AWARDS
FNAMEPOINTSMONTH
----------------------------------
Amy24
Amy17
Gerard33
Wang33
Wang112
Wang18
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
How are the observations sorted?

（A）ENAME POINTS MONTH Wang33 Wang18 Wang112 Gerard33 Amy24 Amy17

（B）ENAME POINTS MONTH Amy24 Amy17 Gerard33 Wang33 Wang18 Wang112

（C）ENAME POINTS MONTH Wang33 Wang112 Wang18 Gerard33 Amy24 Amy17

（D）ENAME POINTS MONTH Wang112 Wang18 Wang33 Gerard33 Amy17 Amy24

正解：C 解答を投票する

質問 17

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 解答を投票する

質問 18

Given the raw data record DEPT:
----|----10---|----20---|----30
Printing 750
The following SAS program is submitted:
data bonus;
infile 'dept';
inputdept$ 1-11 number 13- 15;
<insert statement here>
run;
Which SAS statement completes the program and results in a value of 'Printing750' for the DEPARTMENT variable?

（A）department = dept II number;

（B）department=trim(dept)||put(number,3.);

（C）department = trim(dept) number;

（D）department = left(dept) II number;

正解：B 解答を投票する

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

弊社を連絡する

関連リンク

トップ試験