topic Re: SAS Cert Prep Guide 9.4 quiz question Ch4 quiz Q3 in SAS Certification

SAS Cert Prep Guide 9.4 quiz question Ch4 quiz Q3

Teeleaf — Wed, 26 Jun 2019 21:50:52 GMT

Which one is the correct answer? Chapter 4 quiz, question 3, the answer key shows the correct answer is a. However, the explanation seems more like choice b. Below are the answer and question.

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 name

here is the question:

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.

a.
options obs=7;
proc import data="C:\users\test.txt" out=exam dbms=dlm replace;
getnames=yes; run;
proc print data=exam; run;

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;

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

out=exam dbms=dlm replace;
delimiter=' '; getnames=no;
run;
proc print data=exam (obs=7); run;

d.
proc import datafile="c:\users\test.txt" out=exam dbms=csv replace;
delimiter=','; getnames=no;
run;
proc print data=exam; options obs=7;
run;

Re: SAS Cert Prep Guide 9.4 quiz question Ch4 quiz Q3

Reeza — Wed, 26 Jun 2019 22:07:30 GMT

You are correct, but this already noted in the updated errata's here:
https://support.sas.com/content/dam/SAS/support/en/books/errata-base-certified.pdf

Re: SAS Cert Prep Guide 9.4 quiz question Ch4 quiz Q3

Teeleaf — Wed, 26 Jun 2019 23:17:06 GMT

Thanks very much Reeza for the confirmation and updates!!

Re: SAS Cert Prep Guide 9.4 quiz question Ch4 quiz Q3

ganeshmule — Mon, 19 Jul 2021 12:36:23 GMT

i was also had that doubt on wrong option in SAS Prep guid 9.4 has wrong option instead of 'B' they have in the book 'A' which is wrong the right answer is option 'B'.

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;

Re: SAS Cert Prep Guide 9.4 quiz question Ch4 quiz Q3

Reeza — Wed, 21 Jul 2021 17:28:59 GMT

As mentioned previously, this is noted in the errata document. In the 'print era' books cannot be updated after they're published so instead they published a separate document indicating any changes. This document already contains this information.