Date:         Sat, 30 Jul 2005 01:48:55 -0500
Reply-To:     Joyce <joycegeorge@gmail.com>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joyce <joycegeorge@GMAIL.COM>
Subject:      Re: grids in data _null_ output
Comments: To: "Terjeson, Mark (IM&R)" <Mterjeson@russell.com>
In-Reply-To:  <16FD64291482A34F995D2AF14A5C932C44F19D@MAIL002.prod.ds.russell.com>
Content-Type: text/plain; charset=ISO-8859-1

Thank you Joep,David,Andre ,Mark
i will try it on monday...

jo.

On 7/29/05, Terjeson, Mark (IM&R) <Mterjeson@russell.com> wrote:
> Hi,
>
> Here are a couple of quick 'canned' methods, you
> will probably get other different suggestions.
>
>
>
>
> data sample;
>     Description='AAAAA'; DrugA=10; DrugB=15; DrugC=20; output;
>     Description='XXXXX'; DrugA=1.3; DrugB=2.3; DrugC=3.2; output;
> run;
>
>
>
>     ****************;
>     * variation #1 *
>     ****************;
>
> title;
> filename thefile 'c:\temp\outfile.rtf';
> ods rtf file=thefile;
>
> data _null_;
>     file print ods;
>     set sample;
>     put Description DrugA DrugB DrugC;
> run;
>
> ods rtf close;
>
>
>
>     ****************;
>     * variation #2 *
>     ****************;
>
> title;
> filename thefile 'c:\temp\outfile.rtf';
> ods rtf file=thefile;
>
> proc print data=sample noobs;
> run;
>
> ods rtf close;
>
>
>
>
> Hope this is helpful.
>
>
> Mark Terjeson
> Senior Programmer Analyst, IM&R
> Russell Investment Group
>
>
> Russell
> Global Leaders in Multi-Manager Investing
>
>
>
>
>
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
> Joyce
> Sent: Thursday, July 28, 2005 10:18 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: grids in data _null_ output
>
>
> Hi all,
>
> Is there any way to put grids in data _null_ output.
> I want to convert the output to microsoft word or .rtf.
> I tried to use ODS RTF but no vertical lines are coming.
> My output looks like:
>
>
> Description     DrugA     DrugB      DrugC
>
>
> XXXXX              10         15           20
> XXXXX             1.3        2.3          3.2
>
> ...
>
>
> I want to put vertical lines between each column.
> The output is coming from a data _null_ step.
> Please help me to solve this.
>
> Thanks in advance.
>
> jo.
>