Hello I need help with this problem exe in SAS

The data set orion.employee_organization contains information about employee job titles, departments, and managers.

Partial orion.employee_organization (424 Total Observations)

Employee Job Title Department ManagerID

120101 Director Sales Management 120261

120102 Sales Manager Sales Management 120101

120103 Sales Manager Sales Management 120101

120104 Administration Manager Administration 120101

120105 Secretary I Administration 120101

1. makeseparate data set for each department.

Name the data sets work.admin, work.stock, and work.purchasing.

Use conditional logic and explicit OUTPUT statements to write to these data sets depending on whether the value of Department is Administration, Stock & Shipping, or Purchasing, respectively. Ignore all other Department values.

Hint: Be careful with capitalization and the spelling of the Department values.

2.Print work.admin and verify your results. Add an appropriate title.

Partial work.admin (34 Total Observations)

Administration Employees

Obs Employee Job_Title DepartmentManager

1 120104 Administration Manager Administration 120101

2 120105 Secretary I Administration 120101

3 120106 Office Assistant II Administration 120104

4 120107 Office Assistant III Administration 120104

5 120108 Warehouse Assistant II Administration 120104

1. Print work.stock and verify your results. Add an appropriate title.

Partial work.stock (26 Total Observations)

Stock and Shipping Employees

Obs Employee_Job_Title DepartmentManager

1 120670 Shipping ManagerStock & Shipping 120659

2 120671 Shipping Agent III Stock & Shipping 120670

3 120672 Shipping ManagerStock & Shipping 120659

4120673 Shipping Agent II Stock & Shipping 120672

5 120677 Shipping ManagerStock & Shipping 120659

1. Print work.purchasing and verify your results. Add an appropriate title.

Partial work.purchasing (18 Total Observations)

Purchasing Employees

ObsEmployee_ Job_TitleDepartmentManager

1 120728 Purchasing Agent IIPurchasing 120735

2 120729 Purchasing Agent IPurchasing 120735

3 120730 Purchasing Agent IPurchasing 120735

4 120731 Purchasing Agent IIPurchasing 120735

5 120732 Purchasing Agent IIIPurchasing 120736