Hi:
I don't understand...does your data file contain
======================================= and
-----------------------------------------------------------------------
and all the white space, or were those separate records that you were trying to indicate???
What about Date 3/12/09 and Date 3/16/09?? Are those IN the file or your descriptions of the data?? Are they separate files? What about the Received 3/14/09??? Again, part of the data or not??
Also, about the data...in your file, is there really a line break between 33182 and 27666 for example, or if you open the file with Notepad, do you see this.
[pre]
97101, 97440, 67431, 55798, 42905, 22590, 31634, 19139, 20920, 33182, 27666, 27532, 25707, 27494
[/pre]
or is there a line break or carriage return at the end of 33182, as shown below:
[pre]
97101, 97440, 67431, 55798, 42905, 22590, 31634, 19139, 20920, 33182,
27666, 27532, 25707, 27494
[/pre]
You say you want one row per number -- by which I think you mean:
[pre]
97101
97440
67431
55798
42905
22590
31634
19139
20920
33182
27666
27532
25707
27494
[/pre]
What would you call that variable Date_3_12_09??? or just NUM or maybe NUMVAR???? Would you want each observation to consist of only one variable or should each observation look like this (partial output):
[pre]
Date Num
3/12/09 97101
3/12/09 97440
3/12/09 67431
[/pre]
You say that you have a "file" is this an ASCII text file (a file that you can open using Notepad)? Is this data in an Excel spreadsheet??
If you have a truly urgent need for help, then you should open a track with Tech Support. In order to help you here, folks really need to see the actual layout of the file you will be reading (with ------ and =====) if those are in the file, but without those cosmetics if they are not in the file.
Can you show us any code that you have already tried??? To learn how to post code and data, refer to this previous forum posting:
http://support.sas.com/forums/thread.jspa?messageID=27609毙
cynthia