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

出題：1

The following SAS program is submitted:
Data WORK.COMPRESS;
ID = '1968 05-10 567';
NewID = compress (ID, "-");
run;
What will the value of NewID be in the WORK.COMPRESS data set?

A. 19680510567

B. 1968 05-10 567

C. 1968 0510 567

D. 196805-10567

正解：B 解答を投票する

出題：2

The following SAS program is submitted:

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

A. This step does not run because of syntax errors.

B. X would retain its original value of missing.

C. X would get a value of 3.

D. X would get a value of 1.

正解：D 解答を投票する

出題：3

Given the SAS data set PRICES:
PRICES
prodid price
K12S5.10producttype
NETWORKsales
15returns
2
B132S 2.34HARDWARE30010
R18KY21.29SOFTWARE255
3KL8BY 6.37HARDWARE12515
DY65DW 5.60HARDWARE455
DGTY23 4.55HARDWARE672
The following SAS program is submitted:
data hware inter soft;
set prices (keep = producttype price);
if price le 5.00;
if producttype = 'HARDWARE' then output HWARE; else if producttype = 'NETWORK' then output INTER; else if producttype = 'SOFTWARE' then output SOFT; run; How many observations does the HWARE data set contain?

A. 2

B. 4

C. 0

D. 3

正解：A 解答を投票する

出題：4

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

出題：5

The following SAS program is submitted:
data work.test;
array agents{4} $ 12 sales1 - sales4;
run;
Which one of the following represents the variables that are contained in the output data set?

A. SALES1, SALES2, SALES3, SALES4

B. AGENTS1, AGENTS2, AGENTS3, AGENTS4

C. None, the DATA step fails because the ARRAY statement can reference only numeric data.

D. None, the DATA step fails because the ARRAY statement can reference only pre-existing variables.

正解：A 解答を投票する

出題：6

By default, which variables and data values are used to calculate statistics in the MEANS procedure?

A. all missing and non-missing numeric variable values and numbers stored as character variables.

B. all missing and non-missing numeric variable values

C. all non-missing numeric variable values and numbers stored as character variables

D. all non-missing numeric variable values

正解：D 解答を投票する

出題：7

Given the data set WORK.EMPDATA:

Which one of the following where statements would display observations with job titles containing the word 'Manager'?

A. where upcase(scan(Job_Title,-1,''))='MANAGER';

B. where substr(Job_Title,(length(Job_Title)-6))='Manager';

C. where Job_Title like '%Manager%';

D. where Job_Title='% Manager ';

正解：C 解答を投票する

出題：8

The following SAS program is submitted:
data temp.x;
set sasuser.y;
run;
What must be submitted prior to this SAS program for the program to execute successfully?

A. A LIBNAME statement for the libref TEMP only must be submitted.

B. LIBNAME statements for the librefs TEMP and SASUSER must be submitted.

C. A LIBNAME statement for the libref SASUSER only must be submitted.

D. No LIBNAME statement needs to be submitted.

正解：A 解答を投票する

出題：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. nocounts

B. norow nocol

C. freq percent

D. norowcount nocolcount

正解：B 解答を投票する

出題：10

The following SAS program is submitted:
data work.retail;
cost = '20000';
total = .10 * cost;
run;
Which one of the following is the value of the variable TOTAL in the output data set?

A. '' (missing character value)

B. 2000

C. . (missing numeric value)

D. '2000'

正解：B 解答を投票する

出題：11

The following SAS program is submitted:
data WORK.DATE_INFO;
X="01Jan1960" D;
run;
What variable X contains what value?

A. the date value 01011960

B. the character value "01Jan1960"

C. the code contains a syntax error and does not execute.

D. the numeric value 0

正解：D 解答を投票する

出題：12

Given the following IF/THEN statement:
If Age NE 16 and Age NE 15 then Group-1;
Which assignment statement for variable Group is functionally equivalent to the original statement used in the above data step?

A. if (Age NE 16) or (Age NE 15) then Group=1;

B. where Age not between (15 and 16) then Group=1;

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

D. if Age not in(15,16) then Group=1;

正解：A 解答を投票する

出題：13

The following SAS program is submitted:
data _null_;
set old (keep = prod sales1 sales2);
file 'file-specification';
put sales1 sales2;
run;
Which one of the following default delimiters separates the fields in the raw data file created?

A. (space)

B. : (colon)

C. , (comma)

D. ; (semicolon)

正解：A 解答を投票する

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