How to convert RTF file as a SAS Dataset

HimaAalamuri — Tue, 14 Oct 2014 06:14:44 GMT

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!!

Hima

Re: How to convert RTF file as a SAS Dataset

Kurt_Bremser — Tue, 14 Oct 2014 06:58:30 GMT

- 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.

Re: How to convert RTF file as a SAS Dataset

LinusH — Tue, 14 Oct 2014 08:08:07 GMT

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.

topic Re: How to convert RTF file as a SAS Dataset in ODS and Base Reporting

How to convert RTF file as a SAS Dataset

Re: How to convert RTF file as a SAS Dataset

Re: How to convert RTF file as a SAS Dataset