Deal of The Day! 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
Jacquline
1 day ago
Totally agree, delimited makes the most sense here!
upvoted 0 times
...
Tamra
7 days ago
Really? I thought COBOL was the way to go for this.
upvoted 0 times
...
Lettie
12 days ago
No way, it has to be the delimited wizard!
upvoted 0 times
...
Anjelica
17 days ago
I think the fixed width option could work too.
upvoted 0 times
...
Mira
22 days ago
Definitely need to use a delimited file for that structure.
upvoted 0 times
...
Brandon
27 days ago
C) Use the New Delimited External File wizard. Anything else would be overkill for this simple file format.
upvoted 0 times
...
Iesha
1 month ago
D) Use the New COBOL Copybook wizard. Because COBOL is the answer to everything, right? *chuckles*
upvoted 0 times
...
Rusty
1 month ago
C) Use the New Delimited External File wizard. This is the way to go, unless you want to spend hours counting character widths.
upvoted 0 times
...
Dulce
1 month ago
A) Use the New User Written External File wizard. Seems like the easiest option to read this custom file format.
upvoted 0 times
...
Brock
2 months 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
2 months 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
2 months 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
3 months 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
3 months 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
3 months ago
I'm not entirely sure, but I remember something about fixed width files. Could that be an option here?
upvoted 0 times
...
Abel
3 months 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
3 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
4 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
4 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
4 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
4 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