support@Free-Braindumps.com
Register Login
Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  1. Home
  2. Exams
  3. SAS Institute
  4. A00-212

SAS Institute A00-212 Exam Actual Questions
SAS Advanced Programming Exam for SAS 9 (Page 6 )

Updated On: 3-Jul-2026
Page 6 of 38
PDF with 184 Questions

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. 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. proc sql;
    Create table combine as
    Select one.id,
    Name, salary from one full join two where one.id=two.id;
    Quit
  3. proc sql;
    Create table combine as
    Select one.id,name,salary from one inner join two on one.id=two.id
    Quit
  4. 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;
    Quit;

Answer(s): D



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. proc sql;
    Contents table testdata.one;
    Quit;
  2. proc sql;
    Describe table testdata.one;
    Quit;
  3. proc sql;
    describe testdata.one;
    Quit;
  4. proc sql;
    Contents testdata.one;
    Quit;

Answer(s): B



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

Answer(s): C



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. proc sql;
    Drop table one;
    Quit;
  2. proc sql;
    Remove table one;
    Quit;
  3. proc sql;
    Delete table one;
    Quit;
  4. proc sql;
    Delete from one;
    Quit;

Answer(s): A



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. COMPANY and DEPT only
  2. COMPANY, COUNTRY and DEPT
  3. COMPANY Only
  4. COMPANY and COUNTRY only

Answer(s): A



  PDF
Viewing page 6 of 38
Viewing questions 26 - 30 out of 184 questions


Post your Comments and Discuss SAS Institute A00-212 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!