A00-212 exam

Which of the following is true about the COMPRESS=YES data set option?A . It is most effective with numeric data that represents large numeric valuesB . It is most effective with character data that contains patterns, rather than simple repetitionsC . It uses the Ross Data Compression method to compress...

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?A . proc sql; delete table one; quit;B . proc sql; alter table one drop num, var; quit;C . proc sql; drop...

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

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?A . Where upcase(name)="upcase(&value)";B ....

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

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

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?A . 0B . NullC . 6D . 3View AnswerAnswer: C

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?A . I/O usage onlyB . CPU usage onlyC . I/O and CPU usageD . temporary disk usageView AnswerAnswer: D

The following SAS program is submitted: data new (bufnp=4); set old(bufno=4); run; Why are the BUFNO options used?A . To reduce the number I/O operationsB . To reduce network trafficC . To reduce memory usageD . To reduce the amount of data readView AnswerAnswer: A

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?A . nullB . 2C . 1D . 1.8View AnswerAnswer: C