October 2019
Intermediate to advanced
430 pages
19h 4m
English
proc sql; create view work.phonelist as /*1*/ select Department format=$25., /*2*/ EmployeeName as Name format=$25., PhoneNumber 'Home Phone' format=$16. from certadv.empadd as a /*3*/ inner join certadv.empph as p on a.EmployeeID = p.EmployeeID inner join certadv.emporg as o on o.EmployeeID = p.EmployeeID where PhoneType='Home'; /*4*/ quit; proc sql number; /*5*/ title 'Sales Management Department Home Phone Numbers'; select Name, PhoneNumber from work.phonelist /*6*/ where Department='Sales Management' /*7*/ order by Name; ...