New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

SAS A00-260 Exam - Topic 9 Question 97 Discussion

Actual exam question for SAS's A00-260 exam
Question #: 97
Topic #: 9
[All A00-260 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

Contribute your Thoughts:

0/2000 characters
Brock
11 days ago
D) Use the New COBOL Copybook wizard. I'm not sure, but this might work since the file has a specific structure.
upvoted 0 times
...
Irene
16 days ago
B) Use the New Fixed Width External File wizard. The file structure seems to have fixed-width fields, so this would be the appropriate option.
upvoted 0 times
...
Hubert
21 days ago
C) Use the New Delimited External File wizard. This is the correct choice since the file has a specific structure with delimiters (line breaks) between the fields.
upvoted 0 times
...
Ernie
26 days ago
I’m confused about the phone number line. Would that affect whether we use a delimited or fixed width approach?
upvoted 0 times
...
Rusty
1 month ago
I practiced a similar question, and I feel like the New User Written External File wizard could be the right choice for custom formats.
upvoted 0 times
...
Annabelle
1 month ago
I'm not entirely sure, but I remember something about fixed width files. Could that be an option here?
upvoted 0 times
...
Abel
1 month ago
I think we might need to use the New Delimited External File wizard since the data seems to be structured with line breaks.
upvoted 0 times
...
Amie
2 months ago
Ugh, I'm really not sure about this. The file format isn't super clear from the question. I'd probably start by trying the New Delimited External File wizard and see if that works, but I might need to experiment with the other options if that doesn't pan out.
upvoted 0 times
...
Dick
2 months ago
I'm feeling pretty confident about this one. The description mentions the file has a specific structure, so I think the New User Written External File wizard would be the best approach to define the layout manually.
upvoted 0 times
...
Gwen
2 months ago
Ah, this is a tricky one. I'd want to take a closer look at the file structure to see if there's a clear pattern to the layout. The New COBOL Copybook wizard might be worth considering if the fields have fixed positions.
upvoted 0 times
...
Carmen
2 months ago
Hmm, I'm a bit unsure here. The file structure doesn't seem to match a typical delimited format. Maybe the New Fixed Width External File wizard would be a better fit?
upvoted 0 times
...
Socorro
2 months ago
I think I'd go with option C. The file seems to have a consistent delimiter between the fields, so the New Delimited External File wizard should work well.
upvoted 0 times
...

Save Cancel