SAS® Certified Specialist Prep Guide: Base Programming Using SAS® 9.4 - Quiz Chapter 4 question 3

[monicaco]

Hi all,

I have a question about quiz chapter 4 - question 3:

3. Which program correctly imports only the first seven lines from the external file that is delimited by a period (.) ? Hint: the first line in the external file contains variable names that you want to read in.

Book answer:

3. Correct answer: a

Use the OBS= option in the OPTIONS statement before the IMPORT procedure to limit the number of observations that SAS reads from the external file. When you use the OBS= option in the PROC PRINT statement, the whole file is imported but printing is limited to the number of observations specified. Use DELIMITER='.' to indicate that the delimiter is a period (.) and use GETNAMES=YES to read in the first line, which contains the variable names.

Code a.:

options obs=7;

proc import data="C:\users\test.txt" 

  out=exam 

  dbms=dlm 

  replace; 

  getnames=yes;

run;

proc print data=exam;

run;

However, I think correct answer is code option "B" with the book answer explanation

Code b:

options obs=7;

proc import datafile="c:\users\test.txt" 

  out=exam 

  dbms=dlm 

  replace; 

  delimiter='.'; 

  getnames=yes;

run;

proc print data=exam; run;

Could someone clarify me this point?

Thanks 

[sabisw · Accepted solution]

@monicaco, thank you for your question. 

You are correct it is Option B. 

We have documented this in our Content Updates page.

Thanks,

Samantha