From: Styrmir on
Hi everybody

I hope someone can help me with this. I am currently making a report
where I output a lit with several variables. I now need to enter a
page break according to one variable. Let's say I have 10 customers
that live in New York and 15 in Los Angeles.
I would like a page break where the last cutomer in New York is and a
new page to start where the first customer in Los Angeles.

This is the current code I use:


data _null_;
call symput('datotxt',put(date(),yymmddn8.));
run;
%put &datotxt;

ods escapechar='^';
options pageno=1;
ods rtf file="\\client\I$\Dat\4956ALL\Collection\Various Reports\DCA
Sagsbestilling\INHOUSE_LIST_&datotxt..rtf";
title1 'EB INKASSO Sagsbestilling';
footnote '^{pageof}';
proc print data=rwork.inhouse_Sager_info6 /*noobs*/;
var court zip check date fh cpr_id key_num_acct navn;
run;

ods rtf close;

If anyone has any suggestions I would very thankful

Styrmir Gunnarsson
From: Lou on

"Styrmir" <styrmirg(a)gmail.com> wrote in message
news:8a911cbc-fdff-4a56-af6d-df053a71d27c(a)v20g2000yqv.googlegroups.com...
> Hi everybody
>
> I hope someone can help me with this. I am currently making a report
> where I output a lit with several variables. I now need to enter a
> page break according to one variable. Let's say I have 10 customers
> that live in New York and 15 in Los Angeles.
> I would like a page break where the last cutomer in New York is and a
> new page to start where the first customer in Los Angeles.
>
> This is the current code I use:
>
>
> data _null_;
> call symput('datotxt',put(date(),yymmddn8.));
> run;
> %put &datotxt;
>
> ods escapechar='^';
> options pageno=1;
> ods rtf file="\\client\I$\Dat\4956ALL\Collection\Various Reports\DCA
> Sagsbestilling\INHOUSE_LIST_&datotxt..rtf";
> title1 'EB INKASSO Sagsbestilling';
> footnote '^{pageof}';
> proc print data=rwork.inhouse_Sager_info6 /*noobs*/;
> var court zip check date fh cpr_id key_num_acct navn;
> run;
>
> ods rtf close;
>
> If anyone has any suggestions I would very thankful
>

Since you're using PROC PRINT, the first thing I'd try is the PAGEBY
statement.


 | 
Pages: 1
Prev: Change Colors in Heatmap
Next: daily schedule plot