A00-212 SAS® Certified Advanced Programmer for SAS®9 Dumps Questions

1. When reading a SAS data file, what does the NOBS=option on the SET statement represent?

2. Given the SAS data set SAUSER.HIGWAY:

SASUSER.HIGHWAY

The following SAS program is submitted:

%macro highway;

proc sql nonprint;

%let numgrp=6;

select distinct status into: group1-: group&numgrp from sasuser.highway;

quit;

%do i=1 %to &numgrp;

proc print data =sasuser.highway;

where status ="&&group&I";

run;

%end;

%mend;

%highway

How many reports are produced?

3. The following SAS program is submitted:

%let a=cat;

%macro animal(a=frog);

%let a=bird;

%mend;

%animal(a=pig)

%put a is &a;

What is written to the SAS log?

4. The following SAS program is submitted:

data temp;

array points {2,3} (10,15,20,25,30,35);

run;

What impact does the ARRAY statement have in the Program Data Vector (PDV)?

5. The following SAS program is submitted:

%macro location;

data _null_;

call symput ('dept','sales');

run;

%let country=Germany;

%put_global_;

%mend;

%let company = ABC;

%location;

Which macro variables are written to the SAS log?

6. What is the purpose of the SASFILE statement?

7. Given the SAS date sets CLASS1 and CLASS2

CLASS1 CLASS2

NAME COURSE NAME COURSE

Lauren MATH1 Smith MATH2

Patel MATH1 Farmer MATH2

Chang MATH1 Patel MATH2

Chang MATH3 Hiller MATH2

The following SAS program is submitted:

Proc sql;

Select name from CLASS1

<insert SQL set operator here>

select name from CLASS;

quit;

The following output is desired

NAME

Chang

Chang

Lauren

Which SQL set operator completes the program and generates the desired output?

8. The following SAS program is submitted:

data new (bufnp=4);

set old(bufno=4);

run;

Why are the BUFNO options used?

9. 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?

10. The SAS data set ONE contains fifty million observations and contains the variable PRICE, QUANTITY, FIXED and VARIABLE.

Which SAS program successfully creates three new variables TOTREV, TOTCOST and PROFIT and requires the least amount of CPU resources to be processed?

11. The following SAS program is submitted:

data temp;

set sasuser.history(kep=date);

format date qtr

<insert BY statement here>

if first.date then total=0;

total+1;

if last.date;

run;

proc print data=temp;

run

SASUSER.HISTORY is sorted by the SAS date variable DATE.

The following output is required:

Date Total

1 13

3 15

4 25

Which By statement completes the data step and successfully generates the required output?

12. Which statement(s) in the DATASETS procedure alter(s) the name of a SAS data set stored in a SAS data library?

13. Given has SAS dataset ONE:

The following SAS program is submitted:

Proc sql;

<insert SQL clause here>

from one;

quit;

The following output is desired:

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

14. 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;

<insert BY statement here>

run;

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

15. Given the data set SASHELP.CLASS

SASHELP.CLASS

NAME AGE

Mary 15

Philip 16

Robert 12

Ronald 15

The following SAS program is submitted

%let value = Philip;

proc print data =sashelp.class;

<insert Where statement here>

run;

Which WHERE statement successfully completes the program and produces a report?

16. Following SAS program is submitted:

data temp(<insert option here>);

infile 'rawdata';

input x $ y z;

run;

RAWDATA is a file reference to an external file that is ordered by the variable X.

Which option specifies how the data in the SAS data set TEMP will be sorted?

17. Given the following partial SAS log:

NOTE: SQL table SASHELP.CLASS was created line

Create table SASHELP.CLASS(bufsize=4096)

(

Name char(8);

Gender Char(1);

Age num;

Height num;

Weight num

);

Which SQL procedure statement generated this output?

18. The following SAS program is submitted:

options mprint;

%macro test(parm);

proc &parm data = sashelp.prdsale;

run;

%mend;

%test(print)

What is the result of the MPRINT options?

19. 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

<insert SQL procedure clause here>

quit;

The following output is desired:

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

20. Given the data set SASHELP.CLASS:

SASHELP.CLASS

NAME AGE

Mary 15

Philip 16

Robert 12

Ronald 15

The following SAS program is submitted:

%let value = Philip;

proc print data = sashelp.class;

<insert WHERE statement here>

run;

Which WHERE statement successfully completes the program and procedures a report?

21. Given the SAS dataset ONE

ONE

SALARY

200

205

523

The following SAS program is submitted

Proc sql;

Select * from one

<Insert Where expression here>;

quit;

The following output is desired:

SALARY

200

205

523

Which WHERE expression completes the program and generates the desired output?

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

%macro one;

data _null_;

call symput('proc','measn);

run;

proc &proc data=sashelp.class;

run;

%mend;

%one()

What is the result?

23. The following SAS program is submitted:

%let value=9;

%let add=5;

%let newval=%eval(&value/&add);

What is the value of the macro variable NEWVAL?

24. 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;

<insert By statement here?

Run;

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

25. Which of the following is true about the COMPRESS=YES data set option?

26. The following SAS program is submitted:

data new;

do i=1,2,3

nextfile=compress('March' || |);

infile abc filevar=nextfile

end=eof;

do until (eof);

input dept $sales;

end;

run;

What is the purpose of the FILEVAR=option on the INFILE statement?

27. The following SAS program is submitted:

%micro cols1;

name age;

%mend;

%macro cols2;

height weight

%mend

proc print data=sashelp.class;

<insert VAR statement here>

Run

Which VAR statement successfully completes the program and produces a report?

28. The following SAS program is submitted:

data new(bufsize = 6144 bufno = 4);

set old;

run;

What is the difference between the usage of BUFFSIZE= and BUFNO= options?

29. The SAS data set ONE contains the variables X,Y,Z and W.

The following SAS program is submitted:

Proc transpose data =one

Out=trans

Name=new;

By x;

var y;

run;

What are the names of all of the columns created by the TRANSPOSE procedure?

30. Which SAS integrity constraint type ensures that a specific set or range of values are the only values in a variable?

31. The following SAS program is submitted:

%let test=one;

%let one=two;

%let two=three;

%let three=last;

%put what displays is &&&&&test;

What is the written to the SAS log?

32. The following SAS program is submitted:

data temp:

array points {2,3} (10,15,20,25,30,35);

run;

What impact does the ARRAY statement have in the program Data vector (PDV)?

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

34. What is generated as a result of submitting the RANUNI function with a seed of 123?

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

36. Which of the following statement(s) in the DATASETS procedure alters the name of a SAS data set stored in a SAS data library?

37. The following SAS program is submitted:

<insert statement here>;

%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"?

38. Which one of the following options controls the pagesize of a SAS data set?

39. Given the following SAS data set ONE:

ONE

REP COST

SMITH 200

SMITH 400

JONES 100

SMITH 600

JONES 100

JONES 200

JONES 400

SMITH 800

JONES 100

JONES 300

The following SAS program is submitted:

proc sql;

select rep, avg(cost) as AVERAGE

from one

group by rep

having avg(cost) > (select avg(cost) from one);

quit;

Which one of the following reports is generated?

40. The following SAS program is submitted:

proc sort data = sales tagsort;

by month year;

run;

Which of the following resource(s) is the TAGSORT option reducing?

41. The following SAS program is submitted:

data one;

do i = 1 to 10;

ptobs = ceil(ranuni(0) * totobs);

set temp point = ptobs

nobs = totobs;

output;

end;

stop;

run;

The SAS data set TEMP contains 2,500,000 observations.

Which one of the following represents the possible values for PTOBS?

42. Which one of the following programs contains a syntax error?

43. The following SAS code is submitted:

%macro houses(dsn = houses,sub = RANCH);

data &dsn;

set sasuser.houses;

if style = "¬";

run;

%mend;

%houses(sub = SPLIT)

%houses(dsn = ranch)

%houses(sub = TWOSTORY)

Which one of the following is the value of the automatic macro variable SYSLAST?

44. Given the following SAS data sets ONE and TWO:

ONE TWO

NUM COUNTRY NUM CITY

1 CANADA 3 BERLIN

2 FRANCE 5 TOKYO

3 GERMANY 4 BELGIUM

5 JAPAN

The following SAS program is submitted:

proc sql;

select country

from one

where not exists

(select *

from two

where one.num = two.num);

quit;

Which one of the following reports is generated?

45. Which one of the following statements is true?

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

ONE TWO

# Variable Type Len Pos # Variable Type Len Pos

2 sales Num 8 8 2 budget Num 8 8

1 year Num 8 0 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;

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

47. Given the following SAS statement:

%let idcode = Prod567;

Which one of the following statements stores the value 567 in the macro variable CODENUM?

48. 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?

49. Consider the following SAS log:

229 data sasuser.ranch sasuser.condo / view = sasuser.ranch;

230 set sasuser.houses;

231 if style = 'RANCH' then output sasuser.ranch;

232 else if style = 'CONDO' then output sasuser.condo;

233 run;

NOTE: DATA STEP view saved on file SASUSER.RANCH.

NOTE: A stored DATA STEP view cannot run under a different operating system.

234

235 proc print data = sasuser.condo;

ERROR: File SASUSER.CONDO.DATA does not exist.

236 run;

NOTE: The SAS System stopped processing this step because of errors.

Which one of the following explains why the PRINT procedure fails?

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

51. Given the following SAS data sets ONE and TWO:

ONE TWO

YEAR QTR BUDGET YEAR QTR SALES

2001 3 500 2001 4 300

2001 4 400 2002 1 600

2002 1 700

The following SAS program is submitted:

proc sql;

select one.*, sales

from one, two;

quit;

Which one of the following reports is generated?

52. Given the following SAS data set ONE:

ONE

NUM VAR

1 A

2 B

3 C

Which one of the following SQL programs deletes the SAS data set ONE?

53. The SAS data set TEMP has the following distribution of values for variable A:

A Frequency

1 500,000

2 500,000

6 7,000,000

8 3,000

Which one of the following SAS programs requires the least CPU time to be processed?