topic Re: who can help me with the report using data _null_ in ODS and Base Reporting

who can help me with the report using data _null_

deleted_user — Tue, 12 Oct 2010 09:00:42 GMT

ods pdf file='e:\temp.pdf';
%let ls=130;
%let ps=60;
option mprint pageno=1 nodate ls=&ls ps=&ps FORMCHAR="|_---|+|---+=|-/\<>*" ;
%global LINE BLANK;
data _null_;
call symput('LINE',repeat('-',&ls-1));
call symput('BLANK',repeat(' ',&ls-1));
run;
title1 "&blank";
title2 'SAS' ;
footnote1 'The Power To Know';
footnote2 "&blank";
data _null_;
file print titles linesleft = ll pagesize =&ps linesize = &ls;
put
"SAS"/
"&line"/
"Statistical Analysis System"/
"&blank"/
"SPSS"/
"&line"/
"Statistical Product and Service Solutions"/
"&blank"/;
run;
ods pdf close;

you can run the code first and then help me figure out some questions below
1.I want the font of all those words change to 'Arial'
2.the color of "Statistical Analysis System" change to 'brown',

http://www.pinggu.org/bbs/viewthread.phtid=926456&page=1&fromuid=1142421

Re: who can help me with the report using data _null_

Oleg_L — Tue, 12 Oct 2010 11:36:20 GMT

Hi.
Try this code.

[pre]
proc template;

define style tt1;
style celldatasimple /
font_face=arial
foreground=black;
style celldataemphasis from celldatasimple /
foreground=brown;
end;

define table to1;
column a;
define a;
style= tt1;
cellstyle _val_ in ('Statistical Analysis System') as celldataemphasis, 1 as celldatasimple;
end;
end;
run;

ods pdf file='d:\work\temp001.pdf' style=tt1;
%let ls=130;
%let ps=60;
option mprint pageno=1 nodate ls=&ls ps=&ps FORMCHAR="|_---|+|---+=|-/\*" ;
%global LINE BLANK;
data _null_;
call symput('LINE',repeat('-',&ls-1));
call symput('BLANK',repeat(' ',&ls-1));
run;
title1 "&blank";
title2 'SAS' ;
footnote1 'The Power To Know';
footnote2 "&blank";
data _null_; length a $&ls.;
file print ods=(template='to1' variables=(a (label="")));
a='SAS';put a _ods_;
a="&line"; put a _ods_;
a="Statistical Analysis System"; put a _ods_;
a="&blank"; put a _ods_;
a="SPSS"; put a _ods_;
a="&line"; put a _ods_;
a="Statistical Product and Service Solutions"; put a _ods_;
a="&blank"; put a _ods_;
run;
ods pdf close;

[/pre]

Re: who can help me with the report using data _null_

deleted_user — Tue, 12 Oct 2010 15:58:38 GMT

thx for your kindness!!:)