## DATA Step, Macro, Functions and more

Solved
Occasional Contributor
Posts: 14

Given the following raw data records in DATAFILE.TXT:

----|----10---|----20---|----30
Bill,Football
Tracy,Soccer,Track

The following program is submitted:

data WORK.SPORTS_INFO;
length Fname Sport1-Sport3 \$ 10;
infile ‘DATAFILE.TXT’ dlm=’,’;
input Fname \$ Sport1 \$ Sport2 \$ Sport3 \$;
run;

proc print data=WORK.SPORTS_INFO;
run;

Which output is correct based on the submitted program?

A.

 Obs Fname Sport1 Sport2 Sport3 1 Kim Basketball Golf Tennis 2 Bill Football 3 Tracy Soccer Track

B.

 Obs Fname Sport1 Sport2 Sport3 1 Kim Basketball Golf Tennis 2 Bill Football Football Football 3 Tracy Soccer Track Track

C.

 Obs Fname Sport1 Sport2 Sport3 1 Kim Basketball Golf Tennis 2 Bill Football Tracy Soccer

D.

 Obs Fname Sport1 Sport2 Sport3 1 Kim Basketball Golf Tennis 2 Bill Football

Why is the c and not a?

Thanks

Accepted Solutions
Solution
‎11-14-2016 05:40 PM
PROC Star
Posts: 631

The INPUT statement reads line by line. when the first line is finished reading then it goes to second line to look for data untill the INPUT statement finish reading all variable values. If the line has a missng values you have to use MISSOVER in the INFILE.

The belove code gives option A

data WORK.SPORTS_INFO;

length Fname Sport1-Sport3 \$ 10;

infile 'datafile.txt' dlm=',' missover;

input Fname \$ Sport1 \$ Sport2 \$ Sport3 \$;

run;

proc print data=WORK.SPORTS_INFO;

run;

Thanks,
Suryakiran

All Replies
Solution
‎11-14-2016 05:40 PM
PROC Star
Posts: 631

The INPUT statement reads line by line. when the first line is finished reading then it goes to second line to look for data untill the INPUT statement finish reading all variable values. If the line has a missng values you have to use MISSOVER in the INFILE.

The belove code gives option A

data WORK.SPORTS_INFO;

length Fname Sport1-Sport3 \$ 10;

infile 'datafile.txt' dlm=',' missover;

input Fname \$ Sport1 \$ Sport2 \$ Sport3 \$;

run;

proc print data=WORK.SPORTS_INFO;

run;

Thanks,
Suryakiran
PROC Star
Posts: 631

☑ This topic is solved.

Discussion stats
• 2 replies
• 509 views
• 0 likes
• 2 in conversation