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

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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