Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SAS program A. Consider the following SAS program: data work.workers; infile 'data-inc.txt' input @1 Company $20. @25 State $2. @; if State= then input

image text in transcribedimage text in transcribed

SAS program

A. Consider the following SAS program: data work.workers; infile 'data-inc.txt' input @1 Company $20. @25 State $2. @; if State=" " then input @30 Year; else input 030 City Year; input NumEmployees; run; proc print data-work.workers; run; Create an example data file that is read correctly by the SAS program shown above Your example must have the following properties: o at least five observations altogether at least two observations that use the THEN statement; . at least two observations that use the ELSE statement; . no missing data for the Company, Year, and NumEmployees variables; . no missing values of City when State is not missing Turn in a copy of your data file along with the output generated by the program. You may put them on a single page if they fit. Please read the comment about this problem on the bottom of the next page. A. Consider the following SAS program: data work.workers; infile 'data-inc.txt' input @1 Company $20. @25 State $2. @; if State=" " then input @30 Year; else input 030 City Year; input NumEmployees; run; proc print data-work.workers; run; Create an example data file that is read correctly by the SAS program shown above Your example must have the following properties: o at least five observations altogether at least two observations that use the THEN statement; . at least two observations that use the ELSE statement; . no missing data for the Company, Year, and NumEmployees variables; . no missing values of City when State is not missing Turn in a copy of your data file along with the output generated by the program. You may put them on a single page if they fit. Please read the comment about this problem on the bottom of the next page

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intranet And Web Databases For Dummies

Authors: Paul Litwin

1st Edition

0764502212, 9780764502217

More Books

Students also viewed these Databases questions

Question

Explain the function and purpose of the Job Level Table.

Answered: 1 week ago