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
Content-Type: text/plain; charset="us-ascii"
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?
From: email@example.com [mailto:firstname.lastname@example.org]
On Behalf Of Richard A. DeVenezia
Sent: Tuesday, April 10, 2007 6:58 PM
Subject: Re: Reading Document Properties from Word, PowerPoint, and PDF
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
>> 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
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.
Richard A. DeVenezia