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

質問 1

Which statement correctly computes the average of four numerical values?

（A）average = mean(num1 num2 num3 num4);

（B）average = mean(num1, num4);

（C）average = mean(num1 - num4);

（D）average = mean(ofnum1 - num4)

正解：D 解答を投票する

質問 2

The contents of the SAS data set PERM.JAN_SALES are listed below:
VARIABLE NAME TYPE
idnum character variable
sales_date numeric date value
A comma delimited raw data file needs to be created from the PERM.JAN_SALES data set. The SALES_DATE values need to be in a MMDDYY10 form.
Which one of the following SAS DATA steps correctly creates this raw data file?

（A）libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification' dsd = ','; put idnum sales_date : mmddyy10.; run;

（B）libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification' dlm = ','; put idnum sales_date : mmddyy10.; run;

（C）libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification'; put idnum sales_date : mmddyy10. dsd = ','; run;

（D）libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification'; put idnum sales_date : mmddyy10. dlm = ','; run;

正解：B 解答を投票する

質問 3

The following SAS program is submitted:
data work.retail;
cost = '20000';
total= .10* cost
run;
What is the result?

（A）The value of the variable TOTAL in the output data set is 2000. No messages are written to the SAS log.

（B）The value of the variable TOTAL in the output data set is missing. An error message is written to the SAS log.

（C）The value of the variable TOTAL in the output data set is 2000. A note that conversion has taken place is written to the SAS log.

（D）The variable TOTAL in the output data set has no value. The program fails to execute due to a syntax error.

正解：C 解答を投票する

質問 4

The following SAS program is submitted:

What is the initial value of the variable Total in the following program?

（A）Cannot be determined from the information given

（B）Missing

（C）The value of the first observations Wagerate

（D）0

正解：B 解答を投票する

質問 5

The following SAS program is submitted:
data work.january;
set work.allmonths (keep = product month num_sold cost);
if month = 'Jan' then output work.january;
sales = cost * num_sold;
keep = product sales;
run;
Which variables does the WORK.JANUARY data set contain?

（A）An incomplete output data set is created due to syntax errors.

（B）PRODUCT, SALES, MONTH, NUM_SOLD and COST only

（C）PRODUCT and SALES only

（D）PRODUCT, MONTH, NUM_SOLD and COST only

正解：A 解答を投票する

質問 6

Given the SAS data set WORK.ORDERS:

The variable Order_id is numeric; Customer is character; and Ship_date is a numeric containing a SAS date value.
A programmer would like to create a new variable called Note, that shows a character value with the Order_id and Ship_date shown with a date9. format. For the first observation, Note would look like the following: "Order 9341 shipped on 02FEB2009".
Which of the following statement will correctly create the value and assign it to Note?

（A）note=catx('','Order',order_id,'shipped on',char(ship_date,date9.));

（B）note=catx('','Order',order_id,'shipped on',put(ship_date,date9.));

（C）note=catx('','Order',order_id,'shipped on',transwrd(ship_date,date9.));

（D）note=catx('','Order',order_id,'shipped on',input(ship_date,date9.));

正解：B 解答を投票する

質問 7

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 data set?

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

質問 8

Given the SAS data set WORK.PRODUCTS:

How many variables does the WORK.REVENUE data set contain?

（A）3

（B）4

（C）2

（D）6

正解：C 解答を投票する

質問 9

The following SAS program is submitted:
data work.test;
array items{3} _temporary_;
run;
What are the names of the variable(s) in the WORKTEST data set?

（A）ITEMS1, ITEMS2, ITEMS3

（B）No variables are created because it is a temporary array.

（C）The program fails to execute because there are no variables listed on the ARRAY statement.

（D）ITEMS

正解：B 解答を投票する

質問 10

The following SAS program is submitted:
data work.test;
set work.staff (keep = jansales febsales marsales);
array diff_sales{3} difsales1 - difsales3;
array monthly{3} jansales febsales marsales;
run;
What new variables are created?

（A）MONTHLY1, MONTHLY2 and MONTHLY3

（B）JANSALES, FEBSALES and MARSALES

（C）DIFSALES1, DIFSALES2 and DIFSALES3

（D）DIFF_SALES1, DIFF_SALES2 and DIFF_SALES3

正解：C 解答を投票する

質問 11

Which program displays a listing of all data sets in the SASUSER library?

（A）proc contents lib = sasuser.all; run;

（B）proc contents data = sasuser.all; run;

（C）proc contents lib = sasuser._alI_; run;

（D）proc contents data = sasuser._all_; run;

正解：D 解答を投票する

質問 12

The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below:
WORK.EMPLOYEE WORK.SALARY
fname age name salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
by fname;
totsal + salary;
run;
Which one of the following statements completes the merge of the two data sets by the FNAME variable?

（A）merge work.employeework.salary (rename = (name = fname));

（B）merge work.employeework.salary (fname = name);

（C）merge work.employeework.salary (rename = (fname = name));

（D）merge work.employeework.salary (name = fname);

正解：A 解答を投票する

質問 13

The following SAS program is submitted:

What is the value of the price variable?

（A）25.31

（B）No value is stored.

（C）. (missing numeric value)

（D）$25.31

正解：C 解答を投票する

質問 14

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

（B）4

（C）2

（D）0

正解：C 解答を投票する

質問 15

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

（B）'' (missing character value)

（C）'2000'

（D）. (missing numeric value)

正解：A 解答を投票する

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

弊社を連絡する

関連リンク

トップ試験