INFILE statement

Review the code below

infile cards;

Which option is incompatible with this statement?

a) eof=gohere
b) firstobs=20
c) end=lastline
d) delimiter='ddd'

Infile options

The following SAS program is submitted:

libname rawdata1 'location of SAS data library';
filename rawdata2 'location of raw data file';

data work.testdata;
infile ;
input sales1 sales2;
run;

Which one of the following is needed to complete the program correctly?

A. rawdata1
B. rawdata2
C. 'rawdata1'
D. 'rawdata2'

Infile options

The following SAS program is submitted and reads 100 records from a raw data file:

data work.total;
infile 'file-specification' end = eof;
input name $ salary;
totsal + salary;

run;


Which one of the following IF statements writes the last observation to the output data set?
A. if end = 0;
B. if eof = 0;
C. if end = 1;
D. if eof = 1;

Check the comments for answers...

INFILE statement

A raw data file is listed below.


Jose,47,210
Sue,,108


The following SAS program is submitted using the raw data file above as input:

data employeestats;

input name $ age weight;
run;


Which of the following INFILE statements completes the program and accesses the data
correctly?
a. infile 'file-specification' pad;
b. infile 'file-specification' dsd;
c. infile 'file-specification' dlm=',';
d. infile 'file-specification' missover;



The following output is desired:

name age weight
Jose   47  210
Sue     .    108

Check the comments below for answers....