Date:         Wed, 22 May 2002 08:46:46 -0700
Reply-To:     "Huang, Ya" <ya.huang@PFIZER.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Huang, Ya" <ya.huang@PFIZER.COM>
Subject:      Re: Convert word table into SAS
Comments: To: Mohan <mohmenin@YAHOO.COM>
Content-Type: text/plain

It looks like this might be a solution, although it is
not an automatic one:

. open the word file with table
. in the file menu, select "save as"
. choose the "save as type" as "MS-DOS text with layout (*.asc)"

Once you got the *.asc file, treat it like a regular
text file, use data step to read it in. But you have to
open it with a text editor first, such as notepad, so that you
can manually count the starting column number for each column, then
you can use the column modifier like:

input a 1-5 b $6-15 ...

HTH

Ya Huang


-----Original Message-----
From: Mohan [mailto:mohmenin@YAHOO.COM]
Sent: Wednesday, May 22, 2002 8:19 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Convert word table into SAS


Could someone please let know how to convert a word table into SAS.  I know
to convert a sas output into word. I searched the archives but couldn't
find any info on how to convert from word to sas.  Any suggestions would be
highly welcome.  Thanks.