We have the RTF file which contains hundreds of table mock shells. I want to extract all the titles and footnotes from rtf file and create a Excel file /SAS dataset where I can use them in the macro. I gone through the lot of papers, I am not sure the entire process is depends on SAS programming itself. I will be very thankful for your suggestions and inputs. I am attaching a sample RTF file.
Thanks
I don't open DOCX or similar files due to security issues.
Basically there really isn't any "nice" or easy way to extract anything from Word, RTF or other word processing format file.
Basic procedure is going to be to copy the text from the document and place into an appropriate statement in SAS program code.
thanks for you suggestions, however its little time taking when we have the thousands of tables. by the way sas websites scan for viruses when they upload any document . they will reject if they feel its not secure. Any way its individuals choice to open the uploaded document or not. thanks again.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.