 | Doug,
One pre-SAS possibility might be to save the word document as an html file,
and then import the html file into excel as follows:
Click on Data->Import External Data->Import Data->open the desired file
and then click on the table you wish to capture.
If you then save the file as a worksheet, you can easily import it into SAS.
Similarly, I'd be very surprised if our Perl experts don't already have
sample code to import html tables.
Art
------
On Sun, 23 Jan 2005 21:24:25 +1100, dg wrote:
>I am often sent user documentation (in ms word) that contains text and
>tables. I often need to extract the information contained in the tables,
put
>them into a SAS dataset and then create user formats. I would like to know
>if there is a way to have SAS identify text only in tables, and then to
read
>only key parts of the tables.
>
>for example the tables in the doco are often structured as follows (imagine
>the first part is in column 1 and the second part is in column 2)
>Variable name Cust_ID
>Variable label Customer unique ID
>valid values 0000001 - 9999999
>variable type character
>variable name part_ID
>Variable label Partner of customer unique ID
>valid values 0000001 - 9999999
>variable type character
>
>etc....
>
>I currently create a copy of the doco, delete all of the non-table text,
>copy the tables to excel, tidy them up then import to SAS and run proc
>formats etc, but would love to be able to get SAS to do most of this for
me.
|
|
