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=" " 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
Get step-by-step solutions from verified subject matter experts
