SAS_Institute
A00-280 · Question #54
Given the file sites.csv: Investigator Name,State,Specialty,Visit Fee "Jones, Thomas",NJ,Pediatrics,80 "Smith, Mary",NY,Psychiatry,65 "Kumar, Sanjay",PE,Pediatrics,95 A SAS program is submitted and…
The correct answer is A. firstobs=2. See the full explanation below for the reasoning.
Question
Given the file sites.csv:
Investigator Name,State,Specialty,Visit Fee
"Jones, Thomas",NJ,Pediatrics,80
"Smith, Mary",NY,Psychiatry,65
"Kumar, Sanjay",PE,Pediatrics,95
A SAS program is submitted and produces the following log entry:
data xsites ;
infile 'sites.csv' dlm=',' dsd ;
input investigator_name & state & specialty & visit_fee ;
run ;
NOTE: The infile 'sites.csv' is:
File Name=C:\SAS Exam\Data\sites.csv,
RECFM=V,LRECL=256
NOTE: Invalid data for visit_fee in line 1 35-43.
RULE: ----1----+----2----+----3----+----4----+----5----+----6----+----7----
1 Investigator Name,State,Specialty,Visit Fee 43
Investigator_Name=Invalid State=Invalid Specialty=Specialty visit_fee= . ERROR=1 N=1
NOTE: 4 records were read from the infile 'sites.csv'.
The minimum record length was 32.
The maximum record length was 43.
Which option would you need to add to the INFILE statement to clear the notes from this log?
Options
- Afirstobs=2
- Bmissover
- Clrecl=2
- Dstart=2
How the community answered
(54 responses)- A72% (39)
- B7% (4)
- C17% (9)
- D4% (2)
Community Discussion
No community discussion yet for this question.