BookmarkSubscribeRSS Feed
SASuserlot
Barite | Level 11

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

3 REPLIES 3
ballardw
Super User

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.

SASuserlot
Barite | Level 11

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.

Ksharp
Super User
It is not a rtf file ,it is a word file.
rtf is more like text file, open it via NotePad++ and searching title in it by writing some code.

SAS Innovate 2025: Register Now

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!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1060 views
  • 0 likes
  • 3 in conversation