Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You want to produce a query with the following output: Employee _ ID Last _ Name First _ Name Employment _ Year Number _ Years
You want to produce a query with the following output:
EmployeeID LastName FirstName EmploymentYear NumberYears
Smith Jody
McIntyre Tyler
Poindexter Nakia
Which line of code provides this output?
Question options:
PROC SQL;
SELECT EmpoyeeID LastName, FirstName,
EmploymentYear, EmploymentYear;
FROM EMPLIB.EMPLOYEES;
QUIT;
PROC SQL;
SELECT EmpoyeeID LastName,
FirstName, EmploymentYear,
EmploymentYear AS NumberYears
FROM EMPLIB.EMPLOYEES;
QUIT;
PROC SQL;
SELECT EmpoyeeID LastName, FirstName,
EmploymentYear, EmploymentYear
FROM EMPLIB.EMPLOYEES;
QUIT;
PROC SQL;
SELECT EmpoyeeID LastName,
FirstName, EmploymentYear,
EmploymentYear AS "NumberYears"
FROM EMPLIB.EMPLOYEES;
QUIT;
PROC SQL;
SELECT EmpoyeeID LastName,
FirstName, EmploymentYear,
EmploymentYear AS NumberYears;
FROM EMPLIB.EMPLOYEES;
QUIT;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started