topic Re: OSD PDF in ODS and Base Reporting

OSD PDF

deleted_user — Wed, 21 Mar 2007 10:23:07 GMT

Hi all,
I tried to output the proc print in PDF format using ODS in mainframe. when i opened the PDF file, the proc print output is in table format. I just want to remove the table border. Simply i need the output as we seen in the saslist. Please i need answer ASAP.

Thanks,
Selvi

Re: OSD PDF

deleted_user — Wed, 21 Mar 2007 11:27:39 GMT

Hi,

have you tried to add the option style=printer to your ods statement? I haven't tried this myself, but that would be my first guess/try...

:-)
Jenny
Message was edited by: Jenny at Mar 21, 2007 6:27 AM

Re: OSD PDF

deleted_user — Wed, 21 Mar 2007 11:59:17 GMT

Hi Jenny,

Thanks. Its working. But the column header has the table layout.

Re: OSD PDF

deleted_user — Wed, 21 Mar 2007 12:02:33 GMT

Hi Friends,

the below code working well. But the font size in the PDF file is too small. Please tell me how to increase the size of the font.

ods pdf file=pdfout startpage=now;
data _null_;
file print;
set cdhcpgrep;
format mon $month.;
title ' CDHCPG Report';
put mon y2ddol y2dpct y1ddol y1dpct;
run;

Re: OSD PDF

ScottH_SAS — Wed, 21 Mar 2007 16:10:15 GMT

Selvi,

Using proc template to alter the look of the table can give you what you want. Here is something simple that I put together that I think answers your question.

Let me know if you have more questions.

Scott

Sample program...

options nonumber;

proc template;
define style Styles.noborder;
parent = Styles.minimal;
class Output /
rules = NONE
borderwidth = 0;
end;
run;

ods pdf file="test.pdf" style=styles.noborder;
proc print data=sashelp.class;run;
ods pdf close;

Re: OSD PDF

deleted_user — Thu, 22 Mar 2007 10:38:44 GMT

Hi Scott,

Thanks, I tried this in our SAS version 8.*. It returns error in Class Output/ statement out of proper order. Help me Scott, to resolve in veison 8.

Thanks,
Selvi.

Re: OSD PDF

ScottH_SAS — Thu, 22 Mar 2007 14:57:26 GMT

My fault I was using some 9.2 sytnax. Use this sample program instead.

Thanks
Scott

options nonumber;

proc template;
define style Styles.noborder;
parent = Styles.minimal;
replace Output /
rules = none
frame = Box
cellpadding = 7
cellspacing = 1
borderwidth = 0;
end;
run;

ods pdf file="test.pdf" style=styles.noborder;
proc print data=sashelp.class;run;
ods pdf close;