Sorry -- probably naive question, but,

At 10:57 AM 9/9/2004, Julia Maslak wrote:

>I have a customer who wants me to put his output in Excel or a flat >file. I >am using PROC FREQ. I have converted *.lst output to Excel using >DBMSCopy. It's tedious.

There've been a number of suggestions how to write the .LST output to Excel.

I'd ask: why does it make any sense to do so? An Excel spreadsheet has a very definite data model, a rectangular array where each cell holds a character string, a number, or a formula computing a quantity of either type from the values of other cells.

That doesn't look like .LST output at all. I suppose you could write each line to the leftmost cell of a row in Excel; since Excel strings are displayed over as many blank cells to the right as needed, the result would look like the listing. But to what purpose? It seems to use none of Excel's capacities. What does it offer, that a .TXT file doesn't?