Ʈ  |  Contact Us
 
Ȩ > SAS Tech & Tip > SAS
SAS Ceritified Advanced Programmer Ǯ 65-67 2020.03.11
ƹ 313 1
http://www.mysas.co.kr/sas_tiptech/a_all.asp?b_no=11325&cmd=content&bd_no=33

65. The variable attributes of SAS data sets ONE and TWO are shown below:

 

ONE

#

Variable

Type

Len

Pos

2

Sales

Num

8

8

1

Year

Num

8

0

 

TWO

#

Variable

Type

Len

Pos

2

Budget

Num

8

8

3

Sales

Char

8

16

1

Year

Num

8

0

 

Data set ONE contains 100 observations. Data set TWO contains 50 observations. Both data sets are sorted by the variable YEAR.

The following SAS program is submitted:

 

data three;

merge one two;

by year;

run;

 

A. No messages are written to the SAS log.

B. ERROR and WARNING messages are written to the SAS log.

C. Data set THREE is created with two variables and 50 observations.

D. Data set THREE is created with three variables and 100 observations.


[] B

[Ǯ]

Merge ܼ δ data set 뺯 մϴ.

Mergeansdp dlTsms Է ͼƮ BY մϴ.

ƴ϶ (year) Ƽ ϴ. 

 

[ڵ]


 

 

[ùٸڵ]

 

 

 

[]


 

 

 

 

 

66. The following SAS program is submitted:

 

data new (bufsize = 6144 bufno = 4);

set old;

run;

 

Which one of the following describes the difference between the usage of BUFSIZE= and BUFNO= options?

A.BUFSIZE= specifies the size of the input buffer in bytes; BUFNO= specifies the number of input buffers.

B.BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers.

C. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of input buffers.

D. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of output buffers.


[] B

[Ǯ]

BUFSIZE ũ⸦ Ʈ մϴ.

BUFNO մϴ.

 

 

 

 

67. At the start of a new SAS session; the following program is submitted:

 

%macro one;

data _null_;

call symput('proc','means');

run;

proc &proc data=sashelp.class;

run;

%mend;

%one

 

What is the result?

A. The marco variable PRCO is stored in the SAS catalog WORK.SASMACR

B. The program fails to execute because PROC is a reserved word

C. The macro variable PROC is stored in the local symbol table

D. The macro variable PROC is stored in the global symbol table

 

[]D

[Ǯ]

Global Symbol Table Macro Variables

  • SAS ʱȭ˴ϴ.
  • Automatic or System-defined Macro Variables ʱȭ ˴ϴ.
  • SAS delete ˴ϴ.

Global Macro Variable Ϸ

  • %LET (used outside a macro definition)
  • DATA step SYMPUT
  • PROC SQL INTO
  • %GLOBAL

ũο ̸ & ٰ ũ ̸ % ٽϴ.

CALL SYMPUT( ũ ̸, );

̿ ݴ LOCAL SYMBOL TABLE , ũ parameter list , ũ ൿ Ǹ, ũ ˴ϴ.

 

[ڵ]


[]



 

 

 

 
 
޴ ȣ
޴ ȣ
 
 SAS Ceritified Advanced Programmer Ǯ 68-70
 SAS Ceritified Advanced Programmer Ǯ 62-64