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

monicaco — Tue, 03 Mar 2020 15:57:29 GMT

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

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

sabisw — Tue, 03 Mar 2020 16:28:26 GMT

@monicaco, thank you for your question.

You are correct it is Option B.

We have documented this in our Content Updates page.

Thanks,

Samantha

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

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

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