Question: 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

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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!