A00-260 practice question 9 of 15
You want to register an external file with the following structure: first line contains Customer First and Last Name second line is address1 third line is address 2 fourth line contains the phone number What action should you take to read this file?
Full set: 70 questionsThe described file has a complex structure where a single logical record spans multiple physical lines. Standard file reading methods, such as delimited or fixed-width, assume one record per line. The "New User Written External File" wizard in SAS Data Integration Studio is specifically designed for such non-standard or complex file layouts. It enables the user to provide a custom SAS DATA step program to read the file, which is necessary to correctly parse the four distinct lines into a single observation for each customer.
B. Use the New Fixed Width External File wizard. This wizard is for files where each record is on a single line, and fields are defined by their starting and ending column positions, which is not the case here.
C. Use the New Delimited External File wizard. This wizard is for files where each record is on a single line, and fields are separated by a specific character (delimiter). This file structure does not use delimiters.
D. Use the New COBOL Copybook wizard. This is a specialized wizard used only when the file's layout is described by a COBOL copybook. The question does not mention a COBOL copybook.
1. SAS Institute Inc. (2017). SAS Data Integration Studio 4.9: User's Guide. Cary, NC: SAS Institute Inc.
Chapter 10, "Working with External Files," Section: "Registering External Files," Page 217. The documentation states, "The New User-Written External File wizard enables you to register an external file that requires a SAS DATA step to read its records. For example, you can use this wizard to read a file that has a complex structure, such as multiple records per observation." This directly supports the use of the User Written wizard for the multi-line record structure described in the question.
2. SAS Institute Inc. (2017). SAS Data Integration Studio 4.9: User's Guide. Cary, NC: SAS Institute Inc.
Chapter 10, "Working with External Files," Section: "Registering Delimited Files," Page 218. This section describes the wizard for delimited files, confirming it is for files where "fields in the file are separated by delimiters." This makes it unsuitable for the given scenario.
Chapter 10, "Working with External Files," Section: "Registering Fixed-Width Files," Page 221. This section explains that the fixed-width wizard is for files where data is organized into columns, which is not the structure presented.
Keep practicing
Take the free A00-260 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other A00-260 practice questions
- Question 1Which statement regarding scheduling SAS Data Integration Studio jobs is true?
- Question 3Assume that you have completed the Register Tables wizard in SAS Data Integration Studio.…
- Question 4Assume that SAS Data Integration Studio Table Loader is being used in a job. The load sty…
- Question 5When using the SCD Type 2 load method in SAS Data Integration Studio, which columns can b…
- Question 6The ability to deploy a SAS Data Integration Studio job as a Web service or a SAS Stored …
- Question 7Which statement correctly defines a System DSN?
