Desktop productivity for business analysts and programmers

How to read PDF File in SAS EG

Reply
Occasional Contributor
Posts: 10

How to read PDF File in SAS EG

Suppose i have call details data in PDF , how can i read it through SAS EG to analyse it further? Any suggession on this ?

I am using SAS EG 5.1 version.

Thanks in Advance

Grand Advisor
Posts: 17,358

Re: How to read PDF File in SAS EG

Do you have SAS Text Miner?  That's the only product I know that supports reading a PDF file. 

Esteemed Advisor
Posts: 6,661

Re: How to read PDF File in SAS EG

If someone wants you to do analysis on some data, they better supply that data in a suitable format.

Even EG 7.11 does not have the option of importing PDFs.

You might be able to copy/paste the list data out of the PDF into a text file that can be imported.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Esteemed Advisor
Esteemed Advisor
Posts: 7,217

Re: How to read PDF File in SAS EG

PDF is not a data transfer format, it is a rendered picture of some coding information.  Trust me, you would be better off typing it all in by hand again rather than try to process it.  Go back to the source and ask them to provide the underlying data.

Grand Advisor
Posts: 17,358

Re: How to read PDF File in SAS EG

If you have Adobe Pro there's an option to convert the file to text and/or extract table information to a text file. It's a manual step but can be batched if you have multiple files. 

Esteemed Advisor
Esteemed Advisor
Posts: 7,217

Re: How to read PDF File in SAS EG

True.  The problem is if you have done anything at all special in the file, it makes it next to impossible to read it without a lot of effort.  Even staright cump of text can lead to all kinds of strange spacings and such like to handle.

Grand Advisor
Posts: 17,358

Re: How to read PDF File in SAS EG

The pro conversion helps generate a relatively clean file vs copy and paste. Or the extract table feature. 

Grand Advisor
Posts: 10,211

Re: How to read PDF File in SAS EG

Also even the Adobe Pro tools only work if the data was actually converted from something text. I have had to do something similar where the 'data' was actually an image format. Resolution was print to TIFF format then "scan" the resulting image file with character recognition software. Then spend a few hours removing odd characters resulting from poor image quality. That process probably only reduced time from re-typing by about 20 percent. If the document had only been one page instead of 30 I would have retyped it from the start.

Ask a Question
Discussion stats
  • 7 replies
  • 232 views
  • 1 like
  • 5 in conversation