Consider the following SAS program:
data work.workers;
infile 'M:sta402data-inc.txt';
input @1 Company $20. @25 State $2. @;
if State=" " then input @30 Year;
else input @30 City Year;
input NumEmployees;
run;
ods rtf bodvtitle file=M:sta402print-inc.rtf;
proc print data=work.workers;
run;
ods rtf close;
Do not write any code for this problem. Instead, use a text editor such as Notepad to create an example text data file that is read correctly by the SAS program shown above. Your example text file must have the following properties: 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 text data file in fixed-width font in your PDF file along with the output generated by the program. You may only change the program above to adjust the folder paths for the two files. No SAS file is required.
Comment regarding Problem A: The trailing single @ at the end of an INPUT statement tells SAS that the very next INPUT statement in the current iteration of the DATA step will read more values from the same data record. To see how this works, you might experiment with the following program:
data atmost;
input a b @;
input c;
input d;
datalines;
1 2 3 4
5 7 90 8
4 2 1 0
3 5 7 .
run;
proc print;
run;
