sas base 70题新题

71.Which one of the following SAS REPORT procedure options controls how column headings are displayed over multiple lines?

a. SPACE=

b. SPLIT=

c. LABEL=

d. BREAK=

Answer: B

72. Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?

A. libnamesasdata 'SAS-data-library';

datasasdata.mydata;

copymydata;

run;

B. libnamesasdata 'SAS-data-library';

datasasdata.mydata;

keepmydata;

run;

C. libnamesasdata 'SAS-data-library';

datasasdata.mydata;

savemydata;

run;

D. libnamesasdata 'SAS-data-library';

datasasdata.mydata;

setmydata;

run;

Answer: D

73. The SAS data set named COMPANY.PRICES is listed below:

COMPANY.PRICES

prodidpriceproducttype sales returns

K12S 5.10 NETWORK 15 2

B132S 2.34 HARDWARE 300 10

R18KY2 1.29 SOFTWARE 25 5

3KL8BY 6.37 HARDWARE 125 15

DY65DW 5.60 HARDWARE 45 5

DGTY23 4.55 HARDWARE 67 2

The following SAS program is submitted:

libnamecompany 'SAS-data-library';

datahware inter soft;

setcompany.prices (keep = producttype price);

if price le 5.00;

ifproducttype = '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. 0

B. 2

C. 4

D. 6

Answer: B

74. The following SAS program is submitted:

datawork.test;

setwork.staff (keep = jansalesfebsalesmarsales);

arraydiff_sales{3} difsales1 - difsales3;

A00-201

https://www.360docs.net/doc/181543739.html, - The Power of Knowing

array monthly{3} jansalesfebsalesmarsales;

run;

Which one of the following represents the new variables that are created?

A. JANSALES, FEBSALES and MARSALES

B. MONTHLY1, MONTHLY2 and MONTHLY3

C. DIFSALES1, DIFSALES2 and DIFSALES3

D. DIFF_SALES1, DIFF_SALES2 and DIFF_SALES3

Answer: C

75. The following SAS DATA step is submitted:

datawork.accountting;

setwork.department;

lengthjobcode$ 12;

run;

The WORK.DEPARTMENT SAS data set contains a character variable named JOBCODE with a length of 5.

Which one of the following is the length of the variable JOBCODE in the output data set?

A. 5

B. 8

C. 12

D. The length can not be determined as the program fails to execute due to errors. Answer: A

procfreq data=sales;

run:

Exhibit: output from the FREQ procedure.

Which one of the following statements completes the program and produces the output?

A. tables region product;

B. tables region* product;

C. tables product region;

D. tables product region*;

Answer: B

77. The following SAS program is submitted:

proc format;

value score 1 - 50 = 'Fail'

51-100='Pass';

run;

proc report data=work .courses nowd;

column exam;

define exam / display format=score.;

run;

The variable EXAM has a value of 50.5.

How will the EXAM variable value be displayed in the REPORT procedure output?

A. Fail

B. Pass

C. 50.5

D. . (missing numeric value)

Answer: C

78. The following SAS program is submitted:

proc means data= sasuser .shoes;

where product in ('sandal' , 'Slipper' , 'Boot');

run;

Which one of the following ODS statements completes the program and sends the report to an HTML file?

A. ods html = 'sales .html';

B. ods file='sales .html';

C. ods file html='sales .html';

D. ods html file='sales. html';

Answer: D

libnamesasdata 'SAS-data-library';

data set;

setsasdata .chemists;

ifjobcode = '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. chem3

B. Unknown

C. Senior Chemist

D. ' ' (missing character value)

Answer: B

80. The contents of the raw data file EMPLOYEE are listed below:

----|----10---|----20---|----30

Ruth 39 11

Jose 32 22

Sue 30 33

John 40 44

The following SAS program is submitted:

data test;

in file' employee';

input employee_ name $ 1-4;

if employee_ name = 'Ruthh' then input idnum 10-11;

else input age 7-8;

run

Which one of the following values does the variable IDNUM contain when the name of the employee is "Ruth"?

A. 11

B. 22

C. 32

D. . (missing numeric value)

Answer: B

81. The following SAS program is submitted:

datawork.january;

setwork.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. PRODUCT and SALES only

B. PRODUCT, MONTH, NUM_SOLD and COST only

C. PRODUCT, SALES, MONTH, NUM_SOLD and COST only

D. An incomplete output data set is created due to syntax errors.

Answer: D

82. The following SAS program is submitted:

datawork.totalsales;

setwork.monthlysales(keep=year product sales);

retrainmontnsales {12};

arraymontnsales {12};

doi=1 to 12;

monthsales{i}=sales;

end;

ent+1;

monthsales{ent}=sales;

run;

The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.

Which one of the following is the result of the above program?

A. The program fails execution due to data errors.

B. The program fails execution due to syntax errors.

C. The program runs with warnings and creates the WORK.TOTALSALES data set with 60 observations.

D. The program runs without errors or warnings and creates the

WORK.TOTALSALES data set with 60 observations.

Answer: B

83. The following SAS program is submitted:

datawork.totalsales (keep=monthsales{12});

setwork.monthlysales (keep=year product sales);

srraymonthsales {12};

doi=1 to 12;

monthsales{i}=sales;

end;

run;

The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.

Which one of the following is the result of the above program?

A. The program fails execution due to data errors.

B. The program fails execution due to syntax errors.

C. The program executes with warnings and creates the WORK.TOTALSALES data set.

D. The program executes without errors or warnings and creates the

WORK.TOTALSALES data set.

Answer: B

84.Which one of the following statements is true regarding the SAS automatic

_ERROR_ variable?

A. The _ERROR_ variable contains the values 'ON' or 'OFF'.

B. The _ERROR_ variable contains the values 'TRUE' or 'FALSE'.

C. The _ERROR_ variable is automatically stored in the resulting SAS data set.

D. The _ERROR_ variable can be used in expressions or calculations in the DATA step.

Answer: D

New Questions:

85. data work.one

length var1 var2 12 (都是character类型的）

set work.two (e.g. var1 length 5)

format var1 20

问最后one里var1 length是多少，应该是12，由最开始的length决定

86. 一个排序的问题

by var1 desceding var2 var3

问三个vars是怎么排序的

应该是var1 var3 ascending，var2 descending

87. 下面哪几种是有效的data set name

DATA

WORK.one

_test

test_

2Test

好像还有几个不记得了

但是最后答案是一共4个有效

88.一个dataset，列出了所有的variables的类型

Name Type

N1 num

N2 num

N3 char

N4 char

问在程序中array{*} _numeric_ 建立了几个variable

答案是0，因为这条命令只是refer了dataset里所有num类型的variables，并没有建立新的变量

89.如果今天是Jan 2，1960

问today（）

答案应该是1

90.obs number

1 25

2 10

3 .

4 20

5 30

问total+number的output是神马

obs number total

1 25 25

2 10 35

3 . 35

4 20 55

5 30 85

91.yearcutoff=1970

理解yearcutoff的意义即可。题目中60必须是1970之后，我选2060年

92.这题之前看到其他帖子介绍了，是个新提。于是背答案了。

四个选项中有两个是input( )，有两个是put( )，显然input( )是错的，于是在put( ) 里面二选一：

A) put(date, date9., worddate20.)

B) put(date, worddate20.)

B为正确答案。

93.对于libref的命名规则也考了，问你以下4个选项有几个是符合规则的。libref is 1 to 8 characters long, begins with a letter or underscore, and contains only letters, numbers, or underscores.

94. ods html file="F:reg1.html"; proc one...

proc two...

run;

odspdf close;