topic Re: Controlling the split of text fields in Proc Report in SAS Programming

Controlling the split of text fields in Proc Report

PGStats — Wed, 01 May 2013 18:41:00 GMT

Hi all, how can you control the position of text splits in Proc Report table cells? I tried using "/" and replacing unwanted splits with nonbreaking spaces but nothing does it. How can the equivalent of option SPLIT= be achieved for destination RTF? Thanks - PG

Re: Controlling the split of text fields in Proc Report

Linlin — Wed, 01 May 2013 20:25:39 GMT

Hi PG,

I wish I were smart enough to provide an answer!:smileysilly::smileyblush:

Re: Controlling the split of text fields in Proc Report

data_null__ — Wed, 01 May 2013 21:14:54 GMT

I think the soft break is /line.

Lookup the topic inline formatting, and provide and small example we can fiddle with.

Your gonna need to start learning RTF codes. :smileycry:

Re: Controlling the split of text fields in Proc Report

PGStats — Wed, 01 May 2013 21:38:45 GMT

Thanks DN for your answer and Linlin for your sympathy. I just found the answer in Art Carpenter's book :

http://books.google.ca/books?id=2XaexgsBRQ0C&lpg=PA283&ots=odCUTOmL4s&dq=SAS%20%22proc%20report%22%20split%20rtf&hl=fr&pg=PA282#v=onepage&q=SAS%20%22proc%20report%22%20split%20rtf&f=false

Using escape character sequences such as ^1n for linefeed and ^_ for nonbreaking space does the trick.

Re: Controlling the split of text fields in Proc Report

Tim_SAS — Thu, 02 May 2013 17:26:42 GMT

PG, while those escape character sequences will certainly work, I'd like to point out that they've been superseded in new releases by the ODS inline functions documented here. For example (assuming the escape character is ~), the linefeed function is ~{newline} and nonbreaking space is ~{nbspace}.