A00-212 Online Practice Questions and Answers
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?
A. data two; set three; set one key = X; run;
B. data two; set three key = X; set one; run;
C. data two; set one; set three key = X; run;
D. data two; set three; set one (key = X); run;
Which one of the following is the purpose of the REUSE= YES option in a compressed SAS data set?
A. It temporarily compresses observations in a SAS data set.
B. It allows users to update the same SAS data set concurrently.
C. It allows new observations to be inserted wherever enough free space exists.
D. It specifies that a new empty data set with a given name replaces an existing data set with the same name.
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
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?
A. The index on STATE is deleted and an index on ST is created
B. The index on STATE is recreated as an index on ST
C. The index on STATE is deleted
D. The index on STATE is updated as an index on ST
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?
A. COMPANY and DEPT only
B. COMPANY, COUNTRY and DEPT
C. COMPANY Only
D. COMPANY and COUNTRY only
Given the SAS data set ONE: ONE
NUM VAR
1 A
2 B
3 C
Which SQL procedure program deletes the data set ONE?
A. proc sql; Drop table one; Quit;
B. proc sql; Remove table one; Quit;
C. proc sql; Delete table one; Quit;
D. proc sql; Delete from one; Quit;
Given the data sets shown on the left, the SAS program shown on the right is submitted.
What will be output by the program?
A. ERROR: Subquery evaluated to more than one row
B. Average of Employment 6
C. Average of Employment 5
D. Average of employment 7
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?
A. DESCRIBE TABLE
B. LIST TABLE
C. VALIDATE TABLE
D. CREATE TABLE
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?
A. MPRINT
B. MLOGIC
C. MSOURCE
D. SOURCE2
Given the data sets: The following SAS program is submitted:
Which result set would be generated?
A. 100
B. 200
C. 300
D. 400