nerdexam
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)
  • A
    72% (39)
  • B
    7% (4)
  • C
    17% (9)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Full A00-280 Practice