SAS Institute A00-212 SAS Advanced Programming Exam for SAS 9 Online Training

Exam4Training is the superlative site from where you can easily get SAS Institute A00-212 SAS Advanced Programming Exam for SAS 9 Online Training. Exam4Training is the most reliable resource for your SAS Institute A00-212 exam. At Exam4Training provide SAS Institute A00-212 SAS Advanced Programming Exam for SAS 9 Online Training, like actual exam questions, dumps and etc. All the SAS Institute Systems Certification A00-212 material is accordingly set by subject matters experts. Exam4Training also offer you to try the free demo, before purchase. Also, we have a refund policy if you fail in the exam so you can claim for your refund confidently.

1. The following SAS program is submitted:

Data sasuser.history;

Set sasuser.history(keep=state x y

Rename = (state=ST));

Total=sum(x, y);

Run;

The SAS data set SASUSER.HISTORY has an index on the variable STATE.

Which describes the result of submitting the SAS program?

2. The following SAS program is submitted:

%macro one (input);

%two;

%put the value is &date;

%mend;

%macro two;

data _null_;

call symput('date','12SEP2008');

run;

%mend;

%let date=31DEC2006;

%one(&date)

What is the result when the %PUT statement executes?

3. Which SET statements option names a variable that contains the number of the observation to read during the current iteration of the DATA step?

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

5. CORRECT TEXT

The following SAS program is submitted:

%macro check(num=4);

%let result=%sysevalf(&num+0.5);

%put result is &result;

%mend;

%check(num=10)

What is the written to the SAS log?

6. The following SAS program is submitted:

%micro test(var);

%let jobs=BLACKSMITH WORDSMITH SWORDSMITH;

%let type=%index(&jobs, &var);

%put type = &type;

%mend;

%test(SMITH)

What is the value of the macro variable TYPE when the %PUT statement executes?

7. The following SAS program is submitted:

%macro check(num=4);

%let result=%eval(&nm gt 5);

%put result is &result;

%mend;

%check (num=10)

What is written to the SAS log?

8. The following SAS program is submitted:

data temp;

length 1 b 3 x;

infile 'file reference';

input a b x;

run;

What is the result?

9. Given the SAS data sets ONE and TWO:

The following SAS program is submitted:

Proc sql;

Select two.*,budget from one <insert JOIN operator here> two on one.year=two.year, Quit;

The following output is desired:

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

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

11. The following SAS program is submitted:

%let dept=prod;

%let prod=merchandise;

The following message is written to the SAS log:

The value is "merchandise"

Which SAS System option writes this message to the SAS log?

12. The SAS data set WORK.TEMPDATA contains the variables FMTNAME, START and LABEL and it consists of 10 observations.

The following SAS program is submitted:

Proc format cntlin=wor.tempdata;

Run;

What is the result of submitting the FORMAT procedure step?

13. The following SAS program is submitted:

date view=sauser.ranch;

describe;

run;

What is the result?

14. Which SAS procedure changes the name of a permanent format for a variable stored in a SAS data set?

15. Given the SAS data set ONE:

ONE

DIVISION SALES

A 1234

A 3654

B 5678

The following SAS program is submitted:

Data_null_;

Set one;

By divition;

If first.division then

Do;

%let mfirst=sales;

end;

run;

What is the value of the macro variable MFRIST when the program finishes execution?

16. The following SAS program is submitted:

%let first=yourname;

%let last=first;

%put &&&last;

What is written to the SAS Log?

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

18. Which SQL procedure program deletes rows from the data set CLASS?

19. The following SAS program is submitted:

%let lib=%upcase(sauser); proc sql;

select nvar form dictionary.tables where libname='&lib"; quit;

Several SAS data sets exist in the SAUSER library.

What is generated as output?

20. The following SAS program is submitted:

%macro loop;

data one;

%do I=1 %to 3;

var&I=&I; %

end

run;

%mend;

%loop

After this program executes; the following is written to the SAS log:

(LOOP): Beginning execution

(LOOP): %DO loop beginning; index variable l; start value is 1; stop value is 3; by value is 1

(LOOP): %DO loop index variable l is now 2; loop will iterate again

(LOOP): %DO loop index variable l is no 3; loop will iterate again

(LOOP): %DO loop index variable l is no 4; loop will iterate again

(LOOP): Ending execution

Which SAS system option displays the notes in the SAS log?

21. Given the SAS data sets ONE and TWO:

The following SAS program is submitted:

Data combine;

Merge one two;

By id;

Run;

Which SQL procedure program procedures the same results?

22. The following SAS program is submitted:

proc contents data = testdata.one;

run;

Which SQL procedure program produces similar information about the column attributes of the dataset TESTDATA.ONE?

23. 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)?

24. Given the SAS data set ONE:

ONE

NUM VAR

1 A

2 B

3 C

Which SQL procedure program deletes the data set ONE?

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

26. What is the purpose of the SASFILE statement?

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

28. The following SAS program is submitted:

data new (bufnp=4);

set old(bufno=4);

run;

Why are the BUFNO options used?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

52. 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)?

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

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

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

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

57. 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"?

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

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

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

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

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

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

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

65. Which one of the following statements is true?

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

67. Given the following SAS statement:

%let idcode = Prod567;

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

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

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

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

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

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

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

74. The following SAS program is submitted:

%let value = 9;

%let value2 = 5;

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

Which one of the following is the resulting value of the macro variable NEWVAL?

75. The following SAS program is submitted:

%let lib = %upcase(sasuser);

proc sql;

select nvar

from dictionary.tables

where libname = "&lib";

quit;

Given that several SAS data sets exist in the SASUSER library, which one of the following is generated as output?

76. Given the following SAS data set ONE:

ONE

GROUP SUM

A 765

B 123

C 564

The following SAS program is submitted:

data _null_;

set one;

call symput(group,sum);

run;

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

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

78. Given the following SAS data set ONE:

ONE

COUNTRY CITY VISIT

USA BOSTON 10

UK LONDON 5

USA DALLAS 10

UK MARLOW 10

USA BOSTON 20

UK LONDON 15

USA DALLAS 10

The following SAS program is submitted:

proc sql;

select country, city, sum(visit) as TOTAL

from one

group by country, city

order by country, total desc;

quit;

Which one of the following reports is generated?

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

ONE TWO

NUM CHAR1 NUM CHAR2

1 A 2 X

2 B 3 Y

4 D 5 V

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

data three;

set one two;

run;

THREE

NUM CHAR1 CHAR2

1 A

2 B

4 D

2 X

3 Y

5 V

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

80. Which one of the following automatic SAS macro variables contains the return code from a previously executed step?

81. The SAS data set ONE has a variable X on which an index has been created. The data sets ONE and THREE are sorted by X.

Which one of the following SAS programs uses the index to select observations from the data set ONE?

82. Given the following SAS data set ONE:

ONE

REP AREA COST

SMITH NORTH 100

SMITH SOUTH 200

JONES EAST 100

SMITH NORTH 300

JONES WEST 100

JONES NORTH 200

JONES NORTH 400

SMITH NORTH 400

JONES WEST 100

JONES WEST 300

The following SAS program is submitted:

proc sql;

select rep, area, count(*) as TOTAL

from one

group by rep, area;

quit;

Which one of the following reports is generated?

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

84. Given the following SAS data set SASUSER.HIGHWAY:

SASUSER.HIGHWAY

STEERING SEATBELT SPEED STATUS COUNT

absent no 0-29 serious 31

absent no 0-29 not 1419

absent no 30-49 serious 191

absent no 30-49 not 2004

absent no 50+ serious 216

The following SAS program is submitted:

%macro highway;

proc sql noprint;

select count(distinct status)

into :numgrp

from sasuser.highway;

%let numgrp = &numgrp;

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 by the above program?

85. Text is sent to the SAS compiler as a result of macro execution.

Which one of the following SAS system options writes that text to the log?

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

87. Which one of the following SAS SORT procedure options eliminates identical consecutive observations?

88. The following SAS program is submitted:

data temp;

array points {3,2}_temporary_ (10,20,30,40,50,60);

score = points {2,1}

run;

Which one of the following is the value of the variable SCORE in the data set TEMP?

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

90. Which one of the following SAS programs uses the most amount of memory resources for output buffers?

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

92. The following SAS program is submitted:

%macro execute;

<insert statement here>

proc print data = sasuser.houses;

run;

%end;

%mend;

Which of the following completes the above program so that it executes on Tuesday?

93. Which one of the following statements is true regarding a SAS DATA step view?

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

ONE TWO

OBS COMMON X OBS COMMON Y

1 A 10 1 A 1

2 A 13 2 A 3

3 A 14 3 B 4

4 B 9 4 B 2

5 C 8 5 C 5

6 C 14

The following SAS DATA step is submitted:

data combine;

merge one two;

by common;

run;

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

95. Assume today is Tuesday, July 23, 2002.

Which one of the following statements submitted at the beginning of a SAS session assigns the value Tuesday, July 23, 2002 to the macro variable START?

96. The following SAS program is submitted:

%macro test(var);

%let jobs = BLACKSMITH WORDSMITH SWORDSMITH;

%let type = %index(&jobs,&var);

%mend;

%test(SMITH)

Which one of the following is the resulting value of the macro variable TYPE?

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

98. Which one of the following options displays the value of a macro variable in the SAS log?

99. The following SAS ARRAY statement is submitted:

array score{*} a4 - a10, a25 ;

Which one of the following is the maximum number of elements stored?

100. When is it appropriate to create indexes on a SAS data set for efficient processing?


 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

  • Sign up
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.
We do not share your personal details with anyone.