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
@monicaco, thank you for your question.
You are correct it is Option B.
We have documented this in our Content Updates page.
Thanks,
Samantha
@monicaco, thank you for your question.
You are correct it is Option B.
We have documented this in our Content Updates page.
Thanks,
Samantha
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.