For Proc report, how to make split='~' work in PDF?

Prev: drop many variables
Next: Keeping trailing zeros in SAS Results viewer,

From: Shirish Nalavade on 2 Sep 2009 17:22

---

Lily,
Split character only works in header and not in data.

'~n' in the data will split the data , first define '~' as escapechar like
below


ods escapechar = '~';

Data ToPrint;
Length TEXT $ 32000;
Input Ids= TEXT=;
Cards;
Ids=1 TEXT=1:RED~nx2:BLUE~nx3:BLACK
;
Run;
ods pdf file='test.pdf' ;
proc report data=toprint nowd;
column ids text;
define ids/width = 6;
define text/flow width = 10;
run;
ods pdf close;


You can also use hex character

Check below link for more info

http://support.sas.com/rnd/base/ods/templateFAQ/report1.html


On Wed, Sep 2, 2009 at 4:44 PM, Peng, Lily <Lily.Peng(a)pharma.com> wrote:

> Hi,
>
> I am using the following code to create a pdf file. However split='~' is
> not working in PDF. Does anybody know how to get it work? Thanks a lot!!
>
>
>
>
> Data ToPrint;
> Length TEXT $ 32000;
> Input Ids= TEXT=;
> Cards;
> Ids=1 TEXT=1:RED~2:BLUE~3:BLACK
> ;
> Run;
> ods pdf file='test.pdf' ;
> proc report data=toprint split='~' nowd;
> column ids text;
> define ids/width = 6;
> define text/flow width = 10;
> run;
> ods pdf close;
>



--
Shirish Nalavade

From: Yu Zhang on 2 Sep 2009 17:25

---

Not sure split option will work for destiantions other than list(output
window). but here is one of ways to get what you ask for:

use ESCAPECHAR.


Data ToPrint;
Length TEXT $ 32000;
Input Ids= TEXT=;
Cards;
Ids=1 TEXT=1:RED^n2:BLUE^n3:BLACK
;
Run;

ods pdf file='test.pdf' ;
ods escapechar='^';
proc report data=toprint split='~' nowd;
column ids text;
define ids/width = 6;
define text/flow width = 10;
run;
ods pdf close;
HTH

YU

On Wed, Sep 2, 2009 at 3:44 PM, Peng, Lily <Lily.Peng(a)pharma.com> wrote:

> Hi,
>
> I am using the following code to create a pdf file. However split='~' is
> not working in PDF. Does anybody know how to get it work? Thanks a lot!!
>
>
>
>
> Data ToPrint;
> Length TEXT $ 32000;
> Input Ids= TEXT=;
> Cards;
> Ids=1 TEXT=1:RED~2:BLUE~3:BLACK
> ;
> Run;
> ods pdf file='test.pdf' ;
> proc report data=toprint split='~' nowd;
> column ids text;
> define ids/width = 6;
> define text/flow width = 10;
> run;
> ods pdf close;
>

From: "Terjeson, Mark" on 2 Sep 2009 17:47

---

Hi Peng,


Add ods escapechar='~';




Change:
ods pdf file='test.pdf' ;
proc report data=toprint split='~' nowd;


To:
ods pdf file='test.pdf' ;
ods escapechar='~';
proc report data=toprint split='~' nowd;




Hope this is helpful.


Mark Terjeson
Investment Business Intelligence
Investment Management & Research
Russell Investments
253-439-2367


Russell
Global Leaders in Multi-Manager Investing





-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of
Peng, Lily
Sent: Wednesday, September 02, 2009 1:44 PM
To: SAS-L(a)LISTSERV.UGA.EDU
Subject: For Proc report, how to make split='~' work in PDF?

Hi,

I am using the following code to create a pdf file. However split='~' is
not working in PDF. Does anybody know how to get it work? Thanks a lot!!




Data ToPrint;
Length TEXT $ 32000;
Input Ids= TEXT=;
Cards;
Ids=1 TEXT=1:RED~2:BLUE~3:BLACK
;
Run;
ods pdf file='test.pdf' ;
proc report data=toprint split='~' nowd;
column ids text;
define ids/width = 6;
define text/flow width = 10;
run;
ods pdf close;

 | 
Pages: 1
Prev: drop many variables
Next: Keeping trailing zeros in SAS Results viewer,