| Date: | Fri, 29 Jul 2005 08:40:18 -0700 |
| Reply-To: | "Terjeson, Mark (IM&R)" <Mterjeson@RUSSELL.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | "Terjeson, Mark (IM&R)" <Mterjeson@RUSSELL.COM> |
| Subject: | Re: grids in data _null_ output |
|
| Content-Type: | text/plain; charset="US-ASCII" |
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.
|