View the step-by-step solution to:

employee_organization contains information about employee job titles, departments, and managers. Partial orion.

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 Manager ID

 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. make separate 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               Department                                     Manager   

               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          Department                               Manager

    1      120670     Shipping Manager          Stock & Shipping     120659

    2      120671     Shipping Agent III         Stock & Shipping     120670

    3      120672     Shipping Manager          Stock & Shipping     120659

    4     120673      Shipping Agent II          Stock & Shipping     120672

    5      120677      Shipping Manager          Stock & Shipping     120659

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

Partial work.purchasing (18 Total Observations)

                        Purchasing Employees

   Obs     Employee_  Job_Title                      Department                    Manager 

   1      120728     Purchasing Agent II    Purchasing     120735

   2      120729     Purchasing Agent I     Purchasing     120735

   3      120730       Purchasing Agent I     Purchasing     120735

   4      120731     Purchasing Agent II    Purchasing     120735

   5      120732     Purchasing Agent III   Purchasing     120736

Top Answer

The answer to this question... View the full answer

departments.PNG

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online