(完整word版)SAS-Base认证考试(70真题+答案详解)

⑧

、

DSD

忽略引号中数值的分隔符；自动将字符数据中的引号去掉；将两个相邻分隔符视为缺失值处理。< /p>

⑨

、

MISSOVER

阻止

INPUT

进入下一行读取，未赋值变量视为缺 失值。

⑩

、

TRUNCOVER

MISSOVER

相似，但在

< br>COLUMN INPUT

或

FORMATTED INPUT

中使用。

比较

@

与

@@

的区别：

·

@

用于

1

个数据行用多个

语句读取，停留到下一个

INPUT< /p>

语句。

·

@@

用于

1

个数据行含有多个观测值 读取时，停留到下一个

DATA

步。

Q 3

The following SAS program is submitted:

data _INFO;

Day=

Yr=1960

X=mdy(Day,01,Yr)

run;

What is the value of the variable X?

A. the numeric value 0

B. the character value

C. a missing value due to syntax errors

D. the step will not compile because of the character argument in the mdy function.

4

答案：

A

本题知识点：数据类型的自动转换

在

SAS

中，日期时间是以

1960

年

1

月

1

日

0

时

0

分

0

秒作为起点的。因此，

mdy(1,1,1960)=0

。

若把日期时间表示为常数时，要使用相应的格式，带单或双引号，在后面紧跟一个

D

（日期）、

T

（时间）、

< br>DT

（日期时间）。

在本题中 ，日期函数的参数应该是数值，若是字符串，会先尝试字符串是否可以转换为数值，这是自动转

< br>换。

自动转换是指系统产生一个临时的变量来完成赋值 或运算。当自动转换发生时，会在

LOG

窗口中给出提示。

1

）、字符型变量

->

数值型变量

在下面的情况中，< /p>

VarB

是一个字符型变量，其它是数字型变量。

·

赋值于一个数字型变量，如：

VarA=VarB;

·

在算术运算中使用，如：

VarA=VarB+0;

·

与一个数字型变量进行比较，如：

if VarB>=VarA;

·

在函数 中，参数要求数字型变量，如：

VarA=sum(VarB,0);

2

）、数值型变量

->

字符型变量

在下面的情况中，< /p>

VarB

是一个数字型变量，其它是字符型变量。

·

赋值于一个字符型变量，如：

VarA=VarB;

·

在与要求字符的运算符一起使用， 如：

VarA=''||VarB;

·

在函数中，参数要求字符型变量， 如：

VarA=trim(VarB);

Q 4

The Excel workbook contains the following four worksheets:

EAST

WEST

NORTH

SOUTH

The following program is submitted:

libname MYXLS '';

5

Which PROC PRINT step correctly displays the NORTH worksheet?

A. proc print data=;run;

B. proc print data=$$;run;

C. proc print data=MYXLS.'NORTH'e;run;

D. proc print data=MYXLS.'NORTH$$'n;run;

答案：

D

本题知识点：打印

Excel

的某个工作表的数据

WHAT IS THAT “$$” CH

ARACTER?

Looking at SAS Explorer it may be surprising that each dataset written to Excel appears twice, once with the

expected name and once with a trailing “$$”.

Unlike a typical data source, data in an Excel spreadsheet need not be left and top aligned. For this Excel has

named ranges which allow data to be placed anywhere inside a spreadsheet. By default SAS reads and writes data

from named ranges on spreadsheets, but will also read spreadsheet data directly in the absence of a named range.

When a new SAS dataset is created in an Excel library, SAS creates both a spreadsheet and a named range. Each

is given the same name, with thespreadsheet denoted by a trailing “$$”.

In the example at right CLASS is the named range created by the Excel engine and CLASS$$ is the spreadsheet

created by the Excel engine to hold the named range. Within SAS, the named range is referred to as ,

and the spreadsheet is referenced using the name literal Wrkbk.’CLASS$$’n.

SAS name literals are name tokens written as strings within quotation marks, followed by the letter n. Name

literals allow the use of special characters that are not otherwise allowed in SAS names , like the “$$” used by the

Excel libname engine to distinguish worksheets from named ranges. For more information see the Recommended

Readings.

摘自《

De-Mystifying the SAS LIBNAME Engine in Microsoft Excel: A Practical Guide

》

Q 5

Which statement specifies that records 1 through 10 are to be read from the raw data file ?

A. infile '' 1-10;

B. input '' stop@10;

C. infile '' obs=10;

D. input '' stop=10;

答案：

C

本题知识点：

INFILE

的选项

FIRSTOBS=

常数，要求从指定的行开始读 取数据

,

而不是从文件的第一个记录开始。

O BS=

常数，指定从一个顺序输入文件中读取数据的最后一个行

(

即第

1

～第

n

行

)

。一个观测可能占

n

行。

6

Q 6

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

101 data Y;

102 set R(keep=product month num_Sold Cost);

103 if Month='Jan' then output Y;

104 Sales=Cost * Num_Sold;

105 keep=Product Sales;

-----

22

ERROR 22-322: Syntax error, expecting one of the following: !,

!!, &, *, **, +, -,

, <=, <>, =, >, >=,

AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL,

NOTIN, OR, ^=, |, ||, ~=.

106 run;

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;

答案：

D

本题知识点：

KEEP

语句与

KEEP=

选项

在处理大型数据集时，

KEEP =

选项的效率较高。

·

KEEP

语句：

KEEP variable(s);

不能用于过程步。

·

KEEP=

选项：

data-set-name( KEEP=variable(s) )

可以用于数据步（如，

DATA

语句、

SET

语句）、过 程步。

其中，

variable(s)

是具体变量，不能是数组、

_N_

、

_ ERROR_

等。

Q 7

7

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

Microsoft Excel?

A. MSOFFICE2K

B. EXCELXP

C. CSVALL

D. WINXP

答案：

D

本题知识点：

ODS

输出

Most of these destinations are designed to create output for viewing on a screen or for printing.

The OUTPUT destination creates SAS data sets. The MARKUP destination is a general purpose

tool for creating output in formats defined by tagsets. This includes XML (eXtensible Markup

Language), EXCELXP, LaTeX, CSV (comma-separated values), and many other formats where data

can be thought of as separated by tags. The DO CUMENT destination, on the other hand, allows

you to create a reusable output “document” that yo u can rerender for any destination. So, if your

boss decides he really wants that report in PDF, not RTF, you can replay the output document

without having to rerun the entire SAS program that created the data. With an output document,

you can also rearrange, duplicate, or delete tables to further customize your output.

摘自《

The Little SAS Book

》

(Fourth) P152

页

Q 8

The SAS data set named contains 10 observations for each department, and is currently ordered by

Department.

The following SAS program is submitted:

data

set (keep=Department MonthlyWageRate);

by Department;

if ment=1 then Payroll=0;

Payroll+(MonthlyWageRate*12);

if ment=1;

run;

Which statement is true?

A. The by statement in the DATA step causes a syntax error.

B. The statement Payroll+(MonthlyWageRate*12); in the data step causes a syntax error.

8

C. The values of the variable Payroll represent the monthly total for each department in the data

set.

D. The values of the variable Payroll represent a monthly total for all values of WAGERATE in the

data set.

答案：

C

本题知识点：类似第

1

题

Q 9

data course;

input exam;

datalines;

50.1

;

run;

proc format;

value score 1

–

50 = ‘Fail’

51

–

100 = ‘Pass’;

run;

proc report data =course nowd;

column exam;

define exam / display format=score.;

run;

What is the value for exam?

A. Fail

B. Pass

C. 50.1

D. No output

答案：

C

本题知识点：

PROC FORMAT

语句

PROC FORMAT;

VALUE name

range-

1=’formatted

-text-

1′ ;

range-

2=’format ted

-text-

2′;

……

range-

< br>n=’formatted

-text-

n’;