A00-212 SAS Advanced Programming Questions and Answers

What is an advantage of using a hash object in a SAS DATA step?

Given the non-indexed SAS data set TEMP:

TEMP

X Y

- -

P 52

P 45

A 13

A 56

R 34

R 12

R 78

The following SAS program is submitted:

Proc print data=temp;

run;

Which BY statement completes the program, creates a listing report that is grouped by X and completes without errors?

Which DICTIONARY table provides information on all the tables containing a variable named LASTNAME?

Given the SAS data sets:

The following SAS DATA step is submitted:

What data values are stored in data set WORK.COMBINE?

Given the non-indexed SAS data set TEMP:

TEMP

X Y

P 52

P 45

A 13

A 56

R 34

R 12

R 78

The following SAS program is submitted:

Proc print data=temp;

Run;

Which by statement completes the program, create a listing report that is grouped by X and completes without errors?

The SAS data set ONE consists of five million observations and has 25 variables.

Which one of the following SAS programs successfully creates three new variables

TOTREV, TOTCOST, and PROFIT and requires the least CPU time to be processed?

The following SAS program is submitted:

data new (bufnp=4);

set old(bufno=4);

run;

Why are the BUFNO options used?

Given has SAS dataset ONE:

The following SAS program is submitted:

Proc sql;

from one;

quit;

The following output is desired:

Which SQL procedure clause completes the program and generates the desired output?

Given the following SAS data sets ONE and TWO:

ONE TWO

NUM CHAR1 NUM CHAR2

1 A1 2 X1

1 A2 2 X2

2 B1 3 Y

2 B2 5 V

4 D

The following SAS program is submitted creating the output table THREE:

proc sql;

create table three as

select one.num, char1, char2

from one, two

where one.num = two.num;

quit;

THREE

NUM CHAR1 CHAR2

2 B1 X1

2 B1 X2

2 B2 X1

2 B2 X2

Which one of the following DATA step programs creates an equivalent SAS data set THREE?

The following SAS program is submitted:

options yearcutoff = 1950;

%macro y2kopt(date);

%if &date >= 14610 %then %do;

options yearcutoff = 2000;

%end;

%else %do;

options yearcutoff = 1900;

%end;

%mend;

data _null_ ;

date = "01jan2000"d;

call symput("date",left(date));

run;

%y2kopt(&date)

The SAS date for January 1, 2000 is 14610 and the SAS system option for

YEARCUTOFF is set to 1920 prior to submitting the above program.

Which one of the following is the value of YEARCUTOFF when the macro finishes execution?

Given the SAS data sets ONE and TWO:

The following SAS program is submitted:

Proc sql;

Select two.*,budget from one two on one.year=two.year,

Quit;

The following output is desired:

Which JOIN operator completes the program and generates the desired output?

The following SAS FORMAT procedure is submitted:

proc format lib = sasuser;

value tempc low < 0 = 'BELOW FREEZING'

0 < 5 = 'COLD'

5 < 10 = 'MILD'

10 < 15 = 'WARM'

15 high = 'HOT';

run;

How is the value 10 displayed when the format TEMPC is applied?

Given the SAS data sets:

The following SAS program is submitted:

What data values are stored in data set WORK.COMBINE?

Which one of the following is an advantage of creating and using a SAS DATA step view?

Given the SAS data set ONE:

ONE

REP COST

SMITH 200

SMITH 400

JONES 100

SMITH 600

JONES 100

The following SAS program is submitted:

Proc sql;

Select rep, avg(cost) as AVERAGE

From one

Group by rep

quit;

The following output is desired:

Which SQL procedure clause completes the program and generates the desired output?

Which option forces the use of a specific index from a data set?

Given the following SAS data set ONE:

ONE

CATEGORY AGE SALARY BONUS

M 28 200 20

M 25 100 10

M 28 300 10

M 33 300 30

F 18 100 50

F 25 200 10

F 35 400 50

The following SQL program is submitted:

proc sql;

create table two as

select distinct age

from one

where age < 33;

quit;

How many rows are written to the SAS data set TWO?

The following SAS program is submitted:

options reuse=YES;

data sasuser RealEstate(compress=CHAR);

set sasuser houses;

run;

What is the effect of the REUSE=YES SAS system option?

Given the following SAS data set ONE:

ONE

CATEGORY AGE SALARY BONUS

----

M 28 200 .

M 25 100 10

F 18 100 50

F 25 200 10

The following SAS program is submitted:

proc sql;

create table two as

select category, salary + bonus as EARNINGS

from one; quit;

Which one of the following represents the data values stored in the data set TWO?

Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS data set?

The following SAS program is submitted:

;

%let development = ontime;

proc print data = sasuser.highway;

title "For &dept";

title2 "This project was completed &development";

run;

Which one of the following statements completes the above and resolves title1 to "For

research&development"?

The DICTIONARY.MACROS table stores information about which of the following?

Given the SAS data set WORK.ONE:

The following SAS program is submitted;

Which result set would be generated?

Which one of the following SAS integrity constraint types ensures that a specific set or range of values are the only values in a variable?