topic Re: How to read rtf files to sas dataset in SAS Programming

How to read rtf files to sas dataset

Sudhakar_A — Fri, 10 Apr 2009 20:05:04 GMT

Hi,

I was trying to read the rtf table output and i want to convert them in to sas dataset for the validation purpose.

Can anyone help me to read the rtf files in to sas.

Thanks in advance

Re: How to read rtf files to sas dataset

sbb — Fri, 10 Apr 2009 20:29:21 GMT

I searched the SAS support http://support.sas.com/ website using Google advanced search argument:

read rtf file site:sas.com

and the SAS conference technical paper below discusses this topic:

Save Those Eyes: A Quality-Control Utility for Checking RTF Output Immediately
And Accurately
http://www2.sas.com/proceedings/sugi31/066-31.pdf

Scott Barry
SBBWorks, Inc.

Re: How to read rtf files to sas dataset

Sudhakar_A — Fri, 10 Apr 2009 22:14:05 GMT

Hi Scott,

Thanks for the document i tried this document its working fine. but only for RTF specification type 1.6 version. There are many types of RTF Spec from 1.6 to 1.8.

I want to read any type of RTF file(Any versions).

Thanks in advance
Sudhakar

Re: How to read rtf files to sas dataset

Cynthia_sas — Sat, 11 Apr 2009 01:30:29 GMT

Hi:
Page 4 of the paper, which Scott referenced, outlines the macro program logic. For the places where the other RTF specifications differ from RTF 1.6, you would need to investigate those specifications and then alter your macro program accordingly.

I believe that ODS RTF creates RTF 1.6 output. I'm not sure whether TAGSETS.RTF also creates RTF 1.6 output; however you could check with Tech Support to be sure.

cynthia

Re: How to read rtf files to sas dataset

Sudhakar_A — Sun, 12 Apr 2009 15:31:43 GMT

hi cynthia,

Thank you for the logic which you gave but i tried it before. It was some thing different from the earlier version. There are many difference between RTF version 1.6 and the other one.

FYI: SAS is generating RTF Version 1.6 files only.

If you can open the same RTF table output generated in SAS with windows 2003 and Windows XP. If you open that with NOTEPAD you can see a lot of difference between them. I need to learn entire RTF spec for 1.6, 1.8 and so on... for converting to SAS dataset. Its keep on changing.

Three factors which plays a role in creating the RTF files
1. SAS
2. Operating system ( even same opearting system with different service packs)
3. Microsoft Word installed in the System

I am looking for the consistent way of converting.

Anyway thanks for help.

Sudhakar

Re: How to read rtf files to sas dataset

Duong — Mon, 13 Apr 2009 12:20:37 GMT

Hi Sudharka

This paper describe a method I believe is more general. That is it should not matter
which versions or platforms.

http://www.lexjansen.com/phuse/2008/po/po03.pdf

Regards
Duong
www.tranz.co.uk

Re: How to read rtf files to sas dataset

Doc_Duke — Tue, 14 Apr 2009 00:07:17 GMT

Duong,

Where can we download %RTFParser . The paper makes it look like an interesting tool.

Doc Muhlbaier
Duke

Re: How to read rtf files to sas dataset

Florian_Dymatrix — Wed, 02 Dec 2009 17:15:00 GMT

Hi Duong,

very interesting tool! Same question as Doc, where could I download the SAS macro %RTFParser?

Thanks, Florian

Re: How to read rtf files to sas dataset

HimaAalamuri — Tue, 14 Oct 2014 05:33:10 GMT

Dear all,

Now i am trying to solve this problem. please any one help me how to over come with this problem converting RTF file to SAS dataset. please give me a peace of code for this example. i grow through with all related articles but i dn't solution.

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

With Regards,

Hima

Re: How to read rtf files to sas dataset

Ksharp — Tue, 14 Oct 2014 13:45:10 GMT

Check @Arthur.T and @data _null_ 's paper :

http://support.sas.com/resources/papers/proceedings12/238-2012.pdf