A00-212 SAS Advanced Programming Questions and Answers

Define index (Id_Code) in WORK.CHECK;

Create index (Id_Code) on WORK.CHECK;

Make index = Id_Code from WORK.CHECK;

Create index Id_Code on WORK.CHECK;

Height Weight Name Age

Weight Height

Weight Height Name Age

Name Age Weight Height

No variable are created in the PDV

The variables named POINTS10, POINTS15, POINTS20, POINTS25, POINTS30,

POINTS35 are created in the PDV

The variables named POINTS1, POINTS2, POINTS3 POINTS4, POINTS5,

POINTS6 are created in the PDV

The variables named POINTS11, POINTS12, POINTS21, POINTS22, POINTS23 are created in the PDV

The statement OPTIONS FMTSEARCH = (Mylib Library); is required before the PRINT procedure to attain the resulting output

The statement OPTIONS FMSEARCH = (Library Mylib); is required before the PRINT procedure to attain the resulting output

No OPTIONS FMSEARCH ( ) statement is needed to attain resulting output

The statement OPTIONS FMSEARCH = (Mylib); is required before the print procedure to attain the resulting output

CHECK

NOT NULL

PRIMARY KEY

UNIQUE

DICTIONARY.COLUMNS

DICTIONARY.VARIABLES

DICTIONARY.MEMBERS

DICTIONARY.TABLES

100

200

300

400

using a HAVING clause

using summary functions

referencing a view multiple times in the same program

creating views on tables whose structures remain constant

DATASETS

MODIFY

FORMAT

REGISTRY

It tracks and recycles free space

It allows a permanently stored SAS data set to be replaced

It allows users to access the same SAS data set concurrently

It allows updates in place

Where upcase(name)="upcase(&value)";

Where upcase(name)="%upcase(&value)";

Where upcase(name)=upcase(&value);

Where upcase(name)=%upcase(&value);

&Name2

MATH3

WARNING: Apparent symbolic reference ROOT2 not resolved

MATH1

&RC

&ERR

&SYSRC

&SYSERR

proc sql;

select product.*, cost.unitcost, sales.quantity

from product p, cost c, sales s

where p.item = c.item and

item = s.item;

quit;

proc sql;

select product.*, cost.unitcost, sales.quantity

from product, cost, sales

where product.item = cost.item and

product.item = sales.item;

quit;

proc sql;

select p.*, c.unitcost, s.quantity

from product as p, cost as c, sales as s

where p.item = c.item and

item = s.item;

quit;

proc sql;

select p.*, c.unitcost, s.quantity

from product, cost, sales

where product.item = cost.item and

product.item = sales.item;

quit;

data two;

set three;

set one key = X;

run;

data two;

set three key = X;

set one;

run;

data two;

set one;

set three key = X;

run;

data two;

set three;

set one (key = X);

run;

2

3

5

6

Option A

Option B

Option C

Option D

user defined macro variables only

system defined macro variables only

both user and system defined macro variables

macros stored in the autocall macro library only

A report showing the names of the columns in each table in SASUSER

A report showing the number of columns in each table in SASUSER

A report showing the numeric columns in each table in SASUSER

A report showing the number of numeric columns in each table in SASUSER

Where upcase(name)=%upcase(&value);

Where upcase(name)="upcase(&value)";

Where upcase(name)=upcase(&value);

Where upcase(name)="%upcase(&value)";

Option A

Option B

Option C

Option D

%let codenum = substr(&idcode,length(&idcode)-2);

%let codenum = substr(&idcode,length(&idcode)-3);

%let codenum = %substr(&idcode,%length(&idcode)-2);

%let codenum = %substr(&idcode,%length(&idcode)-3);

proc datasets lib = sasuser.all;

quit;

proc datasets lib = sasuser._all_;

quit;

proc datasets lib = sasuser;

contents data = all;

quit;

proc datasets lib = sasuser;

contents data = _all_;

quit;

It can store an index.

It always accesses the most current data.

It works quickly through multiple passes of the data.

It is useful when the underlying data file structure changes.