Date:         Thu, 21 Aug 2003 10:51:31 -0700
Reply-To:     "Huang, Ya" <yhuang@AMYLIN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Huang, Ya" <yhuang@AMYLIN.COM>
Subject:      Re: proc report/ods pdf, insert blank line after column header.
Comments: To: Chenwei Liu <CLiu@BIOSTAT.BSC.GWU.EDU>
Content-Type: text/plain; charset="iso-8859-1"

This one will gave you enough space between header and
the first row of data. Not sure if it meets your requirement
though, because there is no grid line following the header.

ods pdf file="c:\temp\junk.pdf";

proc report data=sashelp.class nowd
 style(header)=[cellheight=0.8in vjust=top];
column name age sex;
define name /'Name';
define age / 'Age';
define sex /'Sex';
run;

ods pdf close;

Kind regards,

Ya

-----Original Message-----
From: Chenwei Liu [mailto:CLiu@BIOSTAT.BSC.GWU.EDU]
Sent: Thursday, August 21, 2003 9:56 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: proc report/ods pdf, insert blank line after column header.


Yes, I have tried headskip. It doesn't work. According to SAS online doc,
it will not work for html or printer destination.
Now I got one not so easy way to make it work. That's to call define for
each column(exlude the two dummy columns) instead of calling define for _row_.


Hopefully there is another way to do this.


Thanks,

Chenwei


At 09:30 AM 8/21/03 -0700, Huang, Ya wrote:
>Have you tried 'headskip' option?
>
>proc report data=xxx nowd headline headskip;
>...
>
>
>-----Original Message-----
>From: Chenwei Liu [mailto:CLiu@BIOSTAT.BSC.GWU.EDU]
>Sent: Thursday, August 21, 2003 9:18 AM
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: proc report/ods pdf, insert blank line after column header.
>
>
>Hi,
>
>I am trying to insert a blank line after the column header and before the
>first data row. Any body have solved this?
>
>Please see the following code, it can successful insert one blank line as I
>need, but cause other trouble, the dummy variable sep1 sep2 I used (from
>Kelvin's solution days ago) to draw  vertical lines now becomes two black
>columns. Any other possible way to insert blank line?
>
>Thank you,
>
>Chenwei
>
>
>
>
>
>      data out1;
>           set out1 ;
>           obsnum=_n_;       /* observation number */
>           label name1 ='Ēn';
>           format all &centers 4.;
>
>      run;
>
>
>    proc report data=out1 nowd split='/' nocenter
>            style(report)={just=left }
>            style(column)={font_face="Arial" font_size=10pt}
>            style(header)={font_face="Arial" font_size=10pt just=right};
>         column obsnum  name1 sep1 all sep2  &centers;
>         define obsnum /order noprint;
>         define name1 / display style(column)={cellwidth=40mm};
>         define sep1/computed " " style= { Foreground=Black Background=
>                black};
>         define sep2/computed " " style= { Foreground=Black Background=
>                black};
>
>         compute sep1 /char length=1;
>               sep1=" ";
>         endcomp;
>         compute sep2 /char length=1;
>               sep2=" ";
>         endcomp;
>
>        compute obsnum;
>            if obsnum=1 then
>             call define(_row_,"style","style={pretext='Ēn'}");  /* at the
>first observation , insert a line as pretext style*/
>          endcomp;
>
>      ods pdf text="ĒS={font_face='Arial' font_size=12pt font_weight=bold
>           just=center} Table &tabno.. &ttitle";
>      run;