SAS Institute A00-212 SAS Advanced Programming Exam for SAS 9 Online Training
SAS Institute A00-212 Online Training
The questions for A00-212 were last updated at Nov 23,2024.
- Exam Code: A00-212
- Exam Name: SAS Advanced Programming Exam for SAS 9
- Certification Provider: SAS Institute
- Latest update: Nov 23,2024
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?
- A . Where salary is not
- B . Where salary ne null
- C . Where salary is not missing
- D . Where salary ne missing
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?
- A . The marco variable PRCO is stored in the SAS catalog WORK.SASMACR
- B . The program fails to execute because PROC is a reserved word
- C . The macro variable PROC is stored in the local symbol table
- D . The macro variable PROC is stored in the global symbol table
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 . null
- B . 2
- C . 1
- D . 1.8
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?
- A . X;
- B . By X groupd;
- C . By X notsorted;
- D . By descending X;
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 values
- B . It is most effective with character data that contains patterns, rather than simple repetitions
- C . It uses the Ross Data Compression method to compress numeric data
- D . It is most effective with character data that contains repeated characters
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?
- A . It names the variable NEXTFILE, whose value is output to the SAS data set NEW
- B . It names the variable NEXTFILE, whose values point to an aggregate storage location
- C . It names the variable NEXTFILE, whose value is a SAS file reference
- D . It names the variable NEXTFILE, whose change in value causes in INFILE statement to open a new input file
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?
- A . var heigh %cols1;
- B . var %cols1 %cols2 height;
- C . var %cols1 height;
- D . var %cols2 %cols1;
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?
- A . BUFSIZE=specifies the size of the output buffer in kilobytes; BUFNO=specifies the number of output buffers
- B . BUFSIZE= specifies the size of the input buffer in bytes; BUFFNO= specifies the number of input buffers
- C . BUFSIZE= specifies the size of the input buffer in kilobytes; BUFNO=specifies the number of input buffers
- D . BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers
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?
- A . new, X, Y and _COL1_
- B . new, X and COL1 only
- C . new, Y and COL1 only
- D . new, X and Y only
Which SAS integrity constraint type ensures that a specific set or range of values are the only values in a variable?
- A . CHECK
- B . NOT NULL
- C . PRIMARY KEY
- D . UNIQUE
Latest A00-212 Dumps Valid Version with 184 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
thank you