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 questions
Answer options
A: Use the New User Written External File wizard. Correct answer
B: Use the New Fixed Width External File wizard.
C: Use the New Delimited External File wizard.
D: Use the New COBOL Copybook wizard.
Correct Answer:
A. Use the New User Written External File wizard.
Explanation

The 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.

Why Incorrect

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.

References

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.

Scroll to Top