I copied a table from a pdf file that contained Exam Code and Exam Name and pasted it into Excel. The results were pasted into one column instead of two separate ones. I want to read the data like so:
Data I want:
7 United States History
13 Art History
14 Studio Art: Drawing Portfolio
Data I have in Excel. (I also pasted it into Notepad with similar results).
|United States History|
|Studio Art: Drawing Portfolio|
|Studio Art: 2-D Design Portfolio|
|Studio Art: 3-D Design Portfolio|
If you have Adobe Professional it can convert the doc to Excel or Word and will save the formatting, at least better than copy and paste.
If you don't have Adobe Professional, you can use the second file, the txt file and easily read that in using SAS.
infile 'path to text file' truncover;
input number / name $20.;
Not actually a SAS related question.
You likely need a PDF viewer/editor that has a "Copy TABLE" option to maintain the "columns" in the PDF table. If the PDF data is NOT a table then you're likely going to have a lot of work if you want the result in Excel.
Note that SAS can read that pasted text file (notepad) with a proper data step. Something like
infile 'c:\path\filename.txt' truncover;
informat exam_code best5. exam_name $50.;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.