Date:         Wed, 7 Aug 2002 20:27:56 -0700
Reply-To:     wawl <wawl@263.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         wawl <wawl@263.NET>
Organization: http://groups.google.com/
Subject:      How can i read the plain text?
Content-Type: text/plain; charset=ISO-8859-1

Hi everyone:

I have a plain text wanted to read into sas,but i have to solve a
difficulty .The plain text is like the following:

Total Purchases       |  4849182|6925586|
  From Producers      |  3101012|2185183|
   # Farm and Sideline|     7772|  27725|
      Products        |         |       |
     From Outside     |  2720103|1064369|
  From Wholesalers and|   952993|1574239|
   Retailers          |         |       |
   # From Outside     |   217313| 960939|
  Import              |   791595|3146381|
  Others              |     3582|  19783|

As the file shows, the column 1 of the 3th line is "# Farm and
Sideline Products".But it is a bit long ,so it is wraped in the 4th
line,and the column 2 and column 3 have no values. So the 4th line can
not be read as a record.
How can i completely  read the file to sas with no discarding the long
value of ""# Farm and Sideline Products"?

    Regards.

    Steven Wang
    wawl@263.net
    Department of Statistics ,
    Renmin University of China.