SAS Institute A00-212 Exam Practice Questions (P. 5)
- Full Access (184 questions)
- Six months 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
Question #21

The following SAS program is submitted:
Data combine;
Merge one two;
By id;
Run;
Which SQL procedure program procedures the same results?
- Aproc sql; Create table combine as Select coalesce (one.id, two.id) as id, Name,salary from one, two where one.id=two.id; Quit;
- Bproc sql; Create table combine as Select one.id, Name, salary from one full join two where one.id=two.id; Quit
- Cproc sql; Create table combine as Select one.id,name,salary from one inner join two on one.id=two.id Quit
- Dproc 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;
D

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #22
proc contents data = testdata.one;
run;
Which SQL procedure program produces similar information about the column attributes of the dataset TESTDATA.ONE?
- Aproc sql; Contents table testdata.one; Quit;
- Bproc sql; Describe table testdata.one; Quit;
- Cproc sql; describe testdata.one; Quit;
- Dproc sql; Contents testdata.one; Quit;
B

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #23
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)?
- ANo variable are created in the PDV
- BThe variables named POINTS10, POINTS15, POINTS20, POINTS25, POINTS30, POINTS35 are created in the PDV
- CThe variables named POINTS1, POINTS2, POINTS3 POINTS4, POINTS5, POINTS6 are created in the PDV
- DThe variables named POINTS11, POINTS12, POINTS21, POINTS22, POINTS23 are created in the PDV
C

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #24
ONE -
NUM VAR -
1 A
2 B
3 C
Which SQL procedure program deletes the data set ONE?
- Aproc sql; Drop table one; Quit;
- Bproc sql; Remove table one; Quit;
- Cproc sql; Delete table one; Quit;
- Dproc sql; Delete from one;
A

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #25
%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?
- ACOMPANY and DEPT only
- BCOMPANY, COUNTRY and DEPT
- CCOMPANY Only
- DCOMPANY and COUNTRY only
A

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
All Pages