|
|
 | | From: | dg | | Subject: | reading part of a ms word document into SAS | | Date: | Sun, 23 Jan 2005 21:24:25 +1100 |
|
|
 | Hi,
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.
I have tried to import the tables but the import appears to create more work
than my manual process.
Any help appreciated.
Doug
--
___,
\o
| |>
/ \ . l
____________o
|
|
| | From: | Richard A. DeVenezia | | Subject: | Re: reading part of a ms word document into SAS | | Date: | Sun, 23 Jan 2005 18:14:02 -0500 |
|
|
| dg wrote:
> Hi,
>
> 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.
Doug:
Take a look at
http://www.devenezia.com/downloads/sas/af/?topic=25
--
Richard A. DeVenezia
|
|
|
