topic Re: converting pdf file to sas table in sas studio in SAS Studio

converting pdf file to sas table in sas studio

kate-1mr — Fri, 25 Dec 2020 19:28:36 GMT

Hello everybody 🙂!

Please help me to solve my problem. I want to convert pdf to sas table.

How i can do this? Can I convert pdf to sas table direcly in my sas stydio?

Thanks a lot!!

Re: converting pdf file to sas table in sas studio

Cynthia_sas — Fri, 25 Dec 2020 21:55:25 GMT

Hi:
A PDF file is a proprietary DOCUMENT format, not a table format like Excel or a data structure. If you have the original file from which the PDF document was created, you should see whether that original data file is in a format that can be read and/or imported into SAS tabular format.
Cynthia

Re: converting pdf file to sas table in sas studio

Kurt_Bremser — Fri, 25 Dec 2020 22:26:49 GMT

I would try to copy/paste the table data into a DATALINES block of a DATA step.

Re: converting pdf file to sas table in sas studio

kate-1mr — Sat, 26 Dec 2020 15:38:11 GMT

Thank you very much for your answer!
You taught me a new way to read pdf, but I have 273 pages in pdf format, this is a very large document,
it is possible to use your method when reading large record?
if not, do you know another way or ways to solve my problem?
Thanks a lot for your attention to my problem!

Re: converting pdf file to sas table in sas studio

Tom — Sat, 26 Dec 2020 15:42:14 GMT

Search on-line for some tool that can attempt to convert the content of the PDF into text. Then you can read the text into SAS.

Re: converting pdf file to sas table in sas studio

kate-1mr — Sat, 26 Dec 2020 15:42:48 GMT

Hi! Thank you a lot for your attention to my problem, unfortunately I don't have original file.

Re: converting pdf file to sas table in sas studio

kate-1mr — Sat, 26 Dec 2020 16:18:06 GMT

Thanks you very much for your answer!
I will do so.
I thought there was a way to convert pdf directly to a sas table without additional conversion.
Thank you a lot for attention to my problem.

Re: converting pdf file to sas table in sas studio

Kurt_Bremser — Sat, 26 Dec 2020 16:24:27 GMT

As long as the data fits into the clipboard, you should be good.

You may have to take care of extra lines caused by page breaks (and the header and footer lines).

Re: converting pdf file to sas table in sas studio

Patrick — Thu, 31 Dec 2020 00:21:52 GMT

If the copy/paste clipboard method doesn't work then open source tools to look into for conversion of a pdf into text: Tika, PDFBox and Tabula.

I've used Tika and PDFBox in past projects successfully for such purposes. PDFBox was "better" suited for pdf documents because the Tika version at the time didn't deal nicely with a specific PDF tag. Never used Tabula but it sounds promising.

With PDFBox the whole PDF document got converted into a text file which we then parsed via SAS code (DataFlux actually) to extract what we needed. It will depend on the structure of your source PDF document how much work writing such text parsing code will be.

Re: converting pdf file to sas table in sas studio

kate-1mr — Thu, 31 Dec 2020 14:54:33 GMT

Thank you so much! I have not done this before but i will try!!

Re: converting pdf file to sas table in sas studio

kate-1mr — Thu, 31 Dec 2020 14:56:23 GMT

Thank you so much! I understood!!