Date:         Sat, 8 May 2010 16:28:55 -0700
Reply-To:     Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Subject:      Re: two Proc Report/RTF questions
Comments: To: "Treder, David" <dtreder@GENESEEISD.ORG>
In-Reply-To:  <AC8B27AA4545474BB8F063FDFE5F2C55056A0F13@GISDSERV03.geneseeisd.local>
Content-Type: text/plain; charset=us-ascii

1) I don't know the answer to this.

2a) Have you tried using "STYLE(LINES)={[style-stuff" in the Proc Report Statement?

   proc report
      style(lines)=[foreground=white background=black
              font_style=italic font_weight=bold font_size=5];

2b) Have you tried using in-line styles in the text?  I don't remember whether I've tried that, or whether it worked if I did, but it might work.  See <http://support.sas.com/rnd/base/topics/expv8/inline82.html>.


Incidentally, to avoid unpleasant surprises, I think it is a good practice to ALWAYS code the MISSING option in Proc Report, Proc Means, Proc Summary, and anywhere else it is available.


--
Jack Hamilton
jfh@alumni.stanford.org
Caelum non animum mutant qui trans mare currunt.




On May 8, 2010, at 10:51 , Treder, David wrote:

> I'm learning the ins and outs of proc report - have found lots of helpful papers, but can't seem to find a solution to two (what seem that they should be, anyway) simple problems:
>
>
>
> 1) How can I make a bold line extend down the whole table, when using an across definition? (the 'type' variable in the example)
>
>
>
> 2) How can I modify the font characteristics (font_type, font_size, etc.) of text created by a line statement in a compute block?  ('level' in the example)
>
>
>
> I've included a simplified/contrived dataset, below, to show what it is I'm having difficulty with.
>
>
>
> Thanks for any suggestions,
>
> Dave
>
>
>
> -----------
>
>
>
> data test;
>
> input year $ level rate;
>
> do type = 1 to 3;
>
> do sub = 1 to 3;
>
>  output;
>
> end;
>
> end;
>
> cards;
>
> 07 1 .2
>
> 08 1 .4
>
> 09 1 .25
>
> 07 2 .4
>
> 08 2 .3
>
> 09 2 .5
>
> ;
>
> run;
>
>
>
>
>
>
>
> proc format;
>
> value lvlfmt
>
> 1 = 'School' 2 = 'District';
>
> run;
>
>
>
> ods rtf  file='c:\Rates.rtf';
>
>
>
> PROC REPORT DATA= work.test    nowindows ;
>
> column level sub  type,year,( rate);
>
> DEFINE  level/noprint GROUP ' ';
>
> DEFINE  sub/GROUP STYLE=[just=l] ' ' ;
>
> define type/ across ' ' STYLE=[ just=c  borderrightwidth=5]; /*WOULD LIKE THIS BORDERWIDTH TO CONTINUE TO THE BOTTOM OF THE TABLE*/
>
> define year/across ' ';
>
> DEFINE rate/analysis SUM ' ' format=percent10.;
>
> compute before level;
>
>  line @10 level  lvlfmt.;  /*WOULD LIKE TO BE ABLE TO CHANGE THE LOOK OF THE FONT*/
>
> endcomp;
>
> run; quit;
>
>
>
> ods rtf  close;
>
>
>
>
>
> Scanned by GenNET AV out