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
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 ...
From: Mohan [mailto:mohmenin@YAHOO.COM]
Sent: Wednesday, May 22, 2002 8:19 AM
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.