%TMFILTER is not reading some of the scanned PDFs

[SatishG]

Hi,

I’m using %TMFILTER macro to read PDF files from a directory on my system to create a SAS data set. Some of these  PDFs are scanned copies.The macro reads some of these scanned files but is not reading others.These PDFs are omitted while creating the data set.

In the log file, I see this message for the omitted files:

File could not be filtered: C:\Acads\SAS\XYZ.pdf

Also, on the cmd.exe screen that shows up when we run the macro, I see this error message:

  <error value = "EXRunReport returned error code 960, &apos;exception occurred.........os;: 3rd party filter failed "/>

I don't understand what this error is saying. Appreciate any help in identifying this error.

Thanks,

Satish

[AnnKuo · Accepted solution]

Hi Satish,

The TMFILTER macro relies on the SAS Document Conversion server to extract plain text from various file formats such as PDF, MS/Word, TEXT, HTML/XML, ... etc.  However, it can not convert image files that are scanned copies of PDF files.  The message you are seeing in the Log informs you which file fails to be converted.  In your case, it is most likely because your files are image files.

Hope this helps!

Ann