Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home SAS Institute A00-212

SAS Institute A00-212 Exam Practice Questions (P. 5)

  • Full Access (184 questions)
  • One Year of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #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?
  1. A
    proc sql; Create table combine as Select coalesce (one.id, two.id) as id, Name,salary from one, two where one.id=two.id; Quit;
  2. B
    proc sql; Create table combine as Select one.id, Name, salary from one full join two where one.id=two.id; Quit
  3. C
    proc sql; Create table combine as Select one.id,name,salary from one inner join two on one.id=two.id Quit
  4. D
    proc sql; Create table combine as Select coalesce (one id, two id) as id, Name,salary from one full join two on one.id=two.id;

Correct Answer:
D

Question #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?
  1. A
    proc sql; Contents table testdata.one; Quit;
  2. B
    proc sql; Describe table testdata.one; Quit;
  3. C
    proc sql; describe testdata.one; Quit;
  4. D
    proc sql; Contents testdata.one; Quit;

Correct Answer:
B

Question #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)?
  1. A
    No variable are created in the PDV
  2. B
    The variables named POINTS10, POINTS15, POINTS20, POINTS25, POINTS30, POINTS35 are created in the PDV
  3. C
    The variables named POINTS1, POINTS2, POINTS3 POINTS4, POINTS5, POINTS6 are created in the PDV
  4. D
    The variables named POINTS11, POINTS12, POINTS21, POINTS22, POINTS23 are created in the PDV

Correct Answer:
C

Question #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?
  1. A
    proc sql; Drop table one; Quit;
  2. B
    proc sql; Remove table one; Quit;
  3. C
    proc sql; Delete table one; Quit;
  4. D
    proc sql; Delete from one;

Correct Answer:
A

Question #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?
  1. A
    COMPANY and DEPT only
  2. B
    COMPANY, COUNTRY and DEPT
  3. C
    COMPANY Only
  4. D
    COMPANY and COUNTRY only

Correct Answer:
A

Previous Questions Next Questions

All Pages