08-22-2011 05:49 AM
I had this requirement where i had to import a data table from a pdf into a SAS dataset. My SAS resides in UNIX. So is my pdf... Is there a way where I could acheive this?
Thanks so much in Advance!
08-22-2011 09:00 AM
Since you are on Unix, Nat's paper is probably the way to go. However, I recently discovered some old Windows' software that allowed me to import tables from pdfs that Ghostscript may not have been able to download correctly. While it may not help you in your quest, I thought it worth sharing for others who might confont a similar problem.
Adobe acrobat reader 6 for Windows is still available for free at:http://www.oldapps.com/adobe_reader.php
Similarly, a releated plugin that Adobe also used to provide is available for free at: http://www.pdfhacks.com/TAPS/
When one has Adobe reader 6 installed, with the TAPS plugin,after one clicks on select text they have the option to use a menu item labeled Table/Formatted Text Select Tool. By clicking on that option I found that I could correctly copy and paste tables from pdf files and not have to do any editing of the file to get it into a readable format.
Like I mentioned, may or may not be relevant to you (unless Windows is also part of the equation), but thought that others might find it useful.
07-22-2013 11:37 PM
I am a newbie here. But I do want to offer you some help. I think there are 2 different ways for you to choose from:
1/ You can do some conversion work to your PDF files and make it available for SAS. Using some code to work it out if you are a program developer.
2/ You can choose a fine PDF SDK to help you with your work. I also suggest you choose one whose way of processing is simple and fast. It can save a lot of time for you.
I am not sure whther it will be helpful to you. But I hope you success. Good luck.
01-08-2014 10:01 PM
There is a article from Cornel University, which gives instructions on how to import data from Excel into SAS. Hope it can help you a little.
PS: I want to post the link here but when I copied the link, strange tags happens. So you can google"import a data table from a pdf into a SAS dataset" and the answer is in the second page. By the way, if you find a good solution, please share it with us. Thank you so much.
01-16-2014 02:00 PM
I am new here, any luck as to how to convert PDF files into SAS dataset yet?
I am working as a SAS programmer-right now I too am curious on how to convert pdf file into sas datasets,
like you my SAS and PDF files are persent in the UNIX environment, I am trying to do this to improve the quality
and enhance the QC process, did a little research where you can convert pdf file into .txt file and then try to read into the SAS, but its tedious
I am not a unix person, but I am able to sense that we can easily do these file conversions in UNIX using some script.
Any help will be appreciated.Thanks.