|
Dear All:
I have several text files. All these files contains titles and a table.
I just want to read in the numbers appeared in the table (not include
the number appeared in title and in the table row name and column name)
into a SAS dataset. In the SAS dataset, I want to have three columns,
the first column indicates at which column a particular number appeared
in the old table, the second column indicates at which row a
particular number appeared in the old table, the third column is the
number. The following is one sample of the text file. Any suggestion
will be appreciated.
title
---------------------------------------------------------------------------
column1 ----column2--- ---column3-----
n % n %
----------------------------------------------------------------------------
AAAA 22 10.2 100 100
BBBB 33 12.2 1200 23
CCCC 55 8.9 42 0.3
---------------------------------------------------------------------------
The sas dataset I want to create for the above example is as follows:
1 1 22
1 2 33
1 3 55
2 1 10.2
2 2 12.2
2 3 8.9
3 1 100
3 2 1200
3 3 42
4 1 100
4 2 23
4 3 0.3
Thanks,
Jun
| 
