Date:         Wed, 11 Apr 2007 08:54:50 -0400
Reply-To:     Mike Rhoads <RHOADSM1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mike Rhoads <RHOADSM1@WESTAT.COM>
Subject:      Re: Reading Document Properties from Word, PowerPoint,
              and PDF Files
Comments: To: "Richard A. DeVenezia" <rdevenezia@wildblue.net>,
          Ed Heaton <EdHeaton@WESTAT.com>
In-Reply-To:  <TDUSh.42$tq.108651@news.sisna.com>
Content-Type: text/plain; charset="us-ascii"

Interesting!

I don't know about PDF, but I have noticed in Windows Explorer that when
you point to a Word, PowerPoint, or Excel file, a tool tip comes up that
shows the title, subject, etc.

This suggests to me that maybe there's a Windows API routine that you
could get at from SAS via the SASCBTBL interfaces, without having to
open the files?

Mike Rhoads
Westat
RhoadsM1@Westat.com

-----Original Message-----
From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]
On Behalf Of Richard A. DeVenezia
Sent: Tuesday, April 10, 2007 6:58 PM
To: sas-l@uga.edu
Subject: Re: Reading Document Properties from Word, PowerPoint, and PDF
Files


Ed Heaton wrote:
>> I need to read the title, author, subject, and keywords fields from
>> MS Word, PowerPoint, and PDF files.  Looking for help.  I'm running
>> SAS
>> 9.1.3 and have SAS/ACCESS for OLE DB and ODBC licensed.

A windows shell script can open each of the files and write such
information
to standard output which can be piped or read into SAS.

Here is a sample that is a little like that, it reads information and
creates data suitable for proc import.

http://www.devenezia.com/downloads/sas/macros/index.php?m=doc2sas.sas

--
Richard A. DeVenezia