- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
https://support.sas.com/content/dam/SAS/support/en/books/errata-base-certified.pdf
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
https://support.sas.com/content/dam/SAS/support/en/books/errata-base-certified.pdf
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks very much Reeza for the confirmation and updates!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content