SAS A00-212 Advanced Programming Certified Practice Exam

Sample Questions

Q) Which SQL procedures program deletes rows from the class set of data?

a) proc sql; Select * from the class, where age <(select stop_age the threshold); Stop;

b) proc sql; Table Class edit, delete where age <(select stop_age the threshold); Stop

c) proc sql; Delete the class, where age <(select stop_age the threshold); Stop;

d) proc sql; Alter the classroom, delete the old wording <(select stop_age the threshold); Stop;

Q) The following SAS program is presented: the data proc = testdata.one; to run; Which SQL procedures similar program produces information about the attributes of the columns, the TESTDATA.ONE data set?

a) proc sql; testdata.one table content; Stop;

b) proc sql; Describe testdata.one table; Stop;

c) proc sql; describe testdata.one; Stop;

d) proc sql; testdata.one Content; Stop;

Q) The following SAS program is presented: Temp data; Matrix points {2,3} (10,15,20,25,30,35); to run; What impact has the ARRAY statement they plan vector data (PDV)?

a) No variables are created in POV

b) The variables named POINTS10, POINTS15, POINTS20, POINTS25, POINTS30, POINTS35 are created in the PDV

c) The variables referred to in points 1, POINTS2, points 3 points 4 points 5, 6 points are created in the PDV

d) The variables named POINTS11, POINTS12, POINTS21, POINTS22, POINTS23 are created in POV

Q) Since the SAS data set one: ONE, NUM VAR, 1 A, 2 B, 3 C, SQL procedures Which program deletes the data set ONE?

a) proc sql; drop table one; Stop;

b) proc sql; Remove one table; Stop;

c) proc sql; eliminates one table; Stop;

d) proc sql; Delete by one; Stop;

Q) What is the purpose of SASFILE statement?

a) It calls for SAS data sets to be opened and loaded into SAS memory one page at a time

b) It requires that a given set SAS SAS open and loaded into memory a variable at a time

c) It requires that a set of SAS data be opened and loaded into memory SAS observation at a time

d) It requires that a set of data SAS SAS be opened and loaded into memory in its entirety