topic Re: Read a PDF file in sas in SAS Enterprise Guide

Read a PDF file in sas

saswiki — Fri, 13 Jan 2023 12:57:32 GMT

Hi Experts,

I have a requirement where I have to read a PDF file in SAS; the PDF file is having screenshot of some bills. Can we import this data in SAS as image; If this is not possible, can anyone tell me how to read a readable table format data stored as PDF in SAS.

Thanks

Re: Read a PDF file in sas

Cynthia_sas — Fri, 13 Jan 2023 14:06:18 GMT

Hi:

You might be able to do something like find a program that would translate the document to Word format or plain text format. The challenge that I think you'll run into is that PDF is a proprietary file type. My understanding was that it was stored in binary form. For example, if I create a little table in a PDF file -- just a table, no other text -- from the first 5 rows of SASHELP.CLASS, and then try to open the PDF file in Notepad, it is unreadable, although in Adobe Reader, it is clearly just a little table:

The XML metadata describing the document does not contain any of the table, but the table is stored in the unreadable section at the top of the file. So I think your task is going to be hard without looking for 3rd party tools to translate the PDF into text.

Cynthia

Re: Read a PDF file in sas

Tom — Fri, 13 Jan 2023 14:21:32 GMT

@saswiki wrote:

Hi Experts,

I have a requirement where I have to read a PDF file in SAS; the PDF file is having screenshot of some bills. Can we import this data in SAS as image; If this is not possible, can anyone tell me how to read a readable table format data stored as PDF in SAS.

Thanks

Do you needed take the PDF file apart and show how pick out the image? or do you just need to store the PDF file.

Either way it is not something you would store in a SAS dataset. Store the files into a file system. You could then store a filename or a URL path to the file into a character variable.

An image is not something that Foundation SAS would have any tools to deal with.

Re: Read a PDF file in sas

saswiki — Fri, 13 Jan 2023 14:25:05 GMT

I understood that I am not able to read the image stored in the PDF file. Do we have any option if the PDF is having a table format data, can we import the PDF file into SAS?

Re: Read a PDF file in sas

saswiki — Fri, 13 Jan 2023 14:28:25 GMT

Thanks Cynthia; I understood that we cant directly import the images into SAS. The requirement is to import the PDF which has screenshots and load the screenshots into Azure. I think we should have to use VBA or other tools; Thanks for your time on this.

Re: Read a PDF file in sas

Quentin — Fri, 13 Jan 2023 14:47:48 GMT

I would look to other languages (e.g. python) for this sort of task. But surprisingly (to me) there is a paper that uses SAS to read a pdf file:

https://support.sas.com/resources/papers/proceedings16/9320-2016.pdf

Re: Read a PDF file in sas

AlanC — Sat, 14 Jan 2023 00:05:12 GMT

Ok, do not use VBA for anything. I am converting thousands of lines of VBA due to age and the fact that it is deprecated. No need to go backwards.

I read pdf using C# and GemBox software. You should be able to find a nuget package that can read it using C#. Python should also be able to do it.
You can also use an RPA tool like UiPath or PowerAutomate.

There are also tools that can export PDF to HTML.

Re: Read a PDF file in sas

srk_2023 — Mon, 26 Jun 2023 18:35:56 GMT

1)First read the pdf file as data file via excel, feeding the page which you need

2)This creates a tab in excel with structured data

3)then you can read in sas (Suitable for not many tables)