topic Re: how to put text when a variable CONTinues on the next page in proc report in SAS Health and Life Sciences

how to put text when a variable CONTinues on the next page in proc report

deleted_user — Fri, 20 Feb 2009 18:03:20 GMT

Hello folks,

I have 2 variables, a class term, and a specific term such that for 1 class term value there are many specific term values.

In proc report I have the class term listed before the specific term in the column statement. In the define statement for the class term I specify sort and noprint and I have a compute block where I specify for this variable to print only the first occurance.

The report lists the specific terms indented under the class terms, but if a class term continues on to the next page, you don't see the class term, while you see the rest of the specific terms.

What I want to know is how can I print the class term on the next page, in proc report, if the class term repeats on the next page? I'm looking for an easy solution in proc report. I've tried a number of things in proc report with no luck. I would like to hear from you if you have done this.

thank you,

Anthony

Re: how to put text when a variable CONTinues on the next page in proc report

Cynthia_sas — Fri, 20 Feb 2009 22:36:38 GMT

Hi:
When I run this report (below) I get the "classterm" repeated at the top of the page in the LISTING and RTF destinations in SAS 9.1.3. HTML, of course, has no page breaks, so COMPUTE BEFORE _PAGE_ only appears at the top of each value for CLASSTERM variable. In SAS 9.1.3, the PDF file only uses the COMPUTE BEFORE _PAGE_ at the beginning of each CLASSTERM. However, in SAS 9.2, PDF and RTF outputs both have the same behavior (with the text string at the top of each page).

I'm not exactly sure of what you're trying to do, but if this program doesn't help you, then you might consider contacting Tech Support for more help.

cynthia

[pre]
** make some data;
data examp;
length classterm $16 specific $16;
set sashelp.class;
classterm='First';
specific = catt('aaa',name);;
output;
specific = catt('bbb',name);
output;
specific = catt('ccc',name);
output;

classterm='Second';
specific = catt('xxx',name);
output;
specific = catt('yyy',name);
output;
specific = catt('zzz',name);
output;

run;

options nodate number pageno=1 ls=80 ps=50;
title; footnote;

ods listing;
ods html file='comp_before_page.html' style=sasweb;
ods rtf file='comp_before_page.rtf' ;
ods pdf file='comp_before_page.pdf';
proc report data=examp nowd;
title 'Use Compute Before Page and Compare Different Destinations';
column classterm specific height;
define classterm / order noprint;
define specific / order;
define height / sum;
break after classterm / summarize page;
compute before classterm;
holdterm = classterm;
endcomp;
compute before _page_;
line 'Term: ' holdterm $16.;
endcomp;
run;
ods _all_ close;

[/pre]

Re: how to put text when a variable CONTinues on the next page in proc report

deleted_user — Sun, 22 Feb 2009 06:41:45 GMT

Hello Cynthia

Thank you for the response. I will try this when I get the chance. My output is lst so I don't know if this will work.

This is for doing adverse events incidence tables. Each system class terms has many preferred terms and many times an organ class's preferred term continue on the next page. proc report does not repeat the class term on the next page when the preferred term is indented under the class term, but we want to do it and add the text "(CONT.)" at the end of class term. Some persons developed very complex programming involving pre-processing to do it. I'm searching for an easier way.

Anthony

Re: how to put text when a variable CONTinues on the next page in proc report

Cynthia_sas — Mon, 23 Feb 2009 03:56:40 GMT

Hi:
Starting in SAS 9.2, the TAGSETS.RTF destination will automatically place the string "continued" at the bottom of the output when the output splits across pages.

This doesn't help with LISTING output. the only way to do this for LISTING output may be to post-process the output file. You might search the PharmaSUG archive site, www.lexjansen.com for some more examples.

cynthia

Re: how to put text when a variable CONTinues on the next page in proc report

LawrenceHW — Tue, 24 Mar 2009 14:52:39 GMT

Anthony,

The only way I've found of doing what you're requesting is the pre-processing route.

Cynthia's solution is very elegant but unfortunately isn't really what is needed for AE tables.

What I do is create page breaks (i.e. a paging variable) based on the number of available lines for my table. Make sure that you take into account skips and continued class headings.

I then run a 2nd data step to add an extra line where a class page breaks in the middle of the class. This is where I add the "(Cont.)".

Hope this helps.
Lawrence