SAS_Institute
A00-212 · Question #158
The following SAS program is submitted: proc sql; insert into company.employee(name, salary, birthdate) select name, salary, birthdate from work.newemployees; What is the result of the program…
The correct answer is D. Observations from WORK.NEWEMPLOYEES are appended to the COMPANY.EMPLOYEE. See the full explanation below for the reasoning.
Question
The following SAS program is submitted:
proc sql; insert into company.employee(name, salary, birthdate) select name, salary, birthdate from work.newemployees; What is the result of the program execution?
Options
- AA report of the observations from WORK.NEWEMPLOYEES is created.
- BThree macro variables named NAME, SALARY, and BIRTHDATE are created.
- CAn error message is written to the SAS log because the INSERT statement is invalid in the
- DObservations from WORK.NEWEMPLOYEES are appended to the COMPANY.EMPLOYEE
How the community answered
(41 responses)- A2% (1)
- B12% (5)
- C5% (2)
- D80% (33)
Community Discussion
No community discussion yet for this question.