topic Re: ODS PDF Using Proc Report in ODS and Base Reporting

ODS PDF Using Proc Report

twildone — Thu, 28 May 2015 14:20:03 GMT

Hi....I am trying to create a report in pdf and proc report to generated the data and table for the output. I have attached a word document on how I would like each page to look like and having difficulty in inserting the title, footnote and repeated header on top of each page. Any suggestions and help would be greatly appreciated.....Thanks

Re: ODS PDF Using Proc Report

RW9 — Thu, 28 May 2015 14:26:38 GMT

Simplest way is to use a by group:

proc report data = xyz...;

title 4 "Client Name: #byval1 Report Date From: #byval2";

by client_name...;

...

Re: ODS PDF Using Proc Report

ballardw — Thu, 28 May 2015 15:28:07 GMT

May I say that your dates in the example look a little odd? 201500430

I get that 2015 would be a year but are you using 3 digits for a month?

Re: ODS PDF Using Proc Report

twildone — Thu, 28 May 2015 15:33:44 GMT

Hi Ballardw....thank you for pointing that out....it was error....it should of been 20150430 as I was just creating a template of what I would like the output file to look like.

Re: ODS PDF Using Proc Report

Cynthia_sas — Thu, 28 May 2015 18:38:06 GMT

Your title requirements can be achieved with SAS title statements. They are not tied to PROC REPORT. Here's the first page of the output produced by the code below.

Cynthia

options nodate nonumber;

ods pdf file='c:\temp\spec_header_titles.pdf';
title bold h=14pt 'The First Title';
title2 j=l 'Client Name' j=r "&sysdate";
title3 j=l 'More Stuff' j=r "Something";

proc print data=sashelp.class;
run;

proc report data=sashelp.class nowd;
run;

proc tabulate data=sashelp.class;
class age;
var height weight;
table age all,
(height*n mean) weight*(min max);
run;
ods pdf close;

Re: ODS PDF Using Proc Report

twildone — Fri, 29 May 2015 01:00:30 GMT

Hi Cynthia......Thank you so much. I tried something similar to your example but am still having problems with including a macro variable (for example, &rundate that I had defined) with either the title or footnote statements. I don't believe I enclosed the macro variable in double quotes but will try that and see if that resolves the problem. One other think, is it possible to insert a line after title3 and above the first footnote.

Re: ODS PDF Using Proc Report

Ksharp — Fri, 29 May 2015 13:20:40 GMT

Try style:

ods pdf file='c:\temp\x.pdf' style=journal;

Re: ODS PDF Using Proc Report

twildone — Fri, 29 May 2015 13:27:20 GMT

Hi Xia Keshan....I am using style=journal. I would like to insert a line across the page that would separate the Titles from the Table. I am wondering would I have to use the BORDERBOTTOM?

Re: ODS PDF Using Proc Report

Ksharp — Fri, 29 May 2015 14:23:33 GMT

NO. Try this one:

ods pdf file='c:\temp\x.pdf' style=journal;
title 'xxxxxxxx';
proc report data=sashelp.class nowd style(header)={borderbottomcolor=white};
columns name age;
define name/style(column)={bordertopcolor=white};
define age/style(column)={bordertopcolor=white};
run;
ods pdf close;

Xia Keshan

Re: ODS PDF Using Proc Report

Cynthia_sas — Fri, 29 May 2015 16:12:18 GMT

Hi:

This output was created with the changed code below (using the TITLE statement).

Cynthia

%let rstr = %str( );

%let tstr = %sysfunc(repeat(&rstr,50));

ods escapechar='^';

ods pdf file='c:\temp\spec_header_titlesx.pdf';

title bold h=14pt '1 The First Title';

title2 j=l 'Client Name' j=r "&sysdate";

title3 j=l 'More Stuff' j=r "Something";

title4 "^{style[bordertopwidth=2px bordertopcolor=black] &tstr}";

Re: ODS PDF Using Proc Report

twildone — Fri, 29 May 2015 16:25:44 GMT

Thanks Cyntia...Works perfectly!!!