Cynthia,
Thank you for your quick reply. I do apologize for not being clearer.
This is a text file that can be viewed in notepad. It is generated by someone else. My task is to find the rows that start with a numeric character and then pull that row and all following rows till I run out of data then continue on till I find another row starting with numeric data then pull that data out. I don't need to keep any text or dates.
This is exactly what is in the data file. "Need to update" is the last line of the file.
Test Data
Date 3/12/09
97101, 97440, 67431, 55798, 42905, 22590, 31634, 19139, 20920, 33182,
27666, 27532, 25707, 27494
Date 3/16/09
----------------------------------------------
Received 3/14/09
73307,65046,45434,85498,85704,86975,18305,18754,20098,20990,
72034,72389,43949,74336,75148,95609,27495,27686,27689,28710,
89108,69253,59294,69588,81358,91629,31675,31714,31759,33012,
43141,53205
Need to update
This is the code I have so far but this is just testing against a file with just 2 rows of
97101, 97440, 67431, 55798, 42905, 22590, 31634, 19139, 20920, 33182,
27666, 27532, 25707, 27494
[pre]
filename indata "c:\temp\test.txt";
data multi ;
infile indata dlm=',' ;
input num @@ ;
run ;
[/pre]
I wanted to see how I can parse out the data. I got working but I don't know how to check which row is a numeric row or a character row.
Thank you
... View more
