BookmarkSubscribeRSS Feed
HimaAalamuri
Fluorite | Level 6

Hi Good Morning,

i am trying to convert RTF file to SAS Dataset but i dn't get solution and i go through with some articles also but no use please get me out from this problem.

Study:XXXX                                                                                                                                                Date: todaydate

Listing 10-3

Demographics

_________________________________________________________________________________

                                             Subject/Age/Sex                             Treatment start

                                                                                                          Date

_____________________________________________________________________________________________                            

                                            0001-001/45/M                             19Jan2013

                                            0001-002/55/M                             29Jan2013

                                            0001-003/43/M                             12Jan2013

                                            0001-004/42/M                             15Jan2013

                                            0001-005/55/M                             29Jan2013

                                            0001-006/35/M                             16Jan2013

_____________________________________________________________________________________________________________________________________

Note: All patients are shown.

Thanks in advance!!

Thanks in advance!!

Hima

2 REPLIES 2
Kurt_Bremser
Super User

- save as plain text file

- inspect with a good text editor

- determine how to identify the lines that contain data

- write a data step that reads the text file, discards unwanted lines, and converts the input either with a proper input statement or by manually splitting the _infile_ variable.

LinusH
Tourmaline | Level 20

If this is one time job: copy/paste to flat file format. Edit so it will be in strict columnar format. Going via Excel might help doing the formatting.

If this is a repetitive task: contact the creator of the document and require a different file format.

Data never sleeps

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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
  • 2 replies
  • 1587 views
  • 2 likes
  • 3 in conversation