Data visualization with SAS programming

Proc Report too long/too many rows, will not print

Reply
Contributor
Posts: 20

Proc Report too long/too many rows, will not print

[ Edited ]

I have a proc report portion of an ODS PDF report that is tucked into a Stored Process that runs from Visual Analytics. The report will not render when the row count is above 60 rows. I can program a variable to force two pages and create two tables, one with outobs=50 and another with the "rest" of the results, but there has to be a simpler way. Is there no Break option or Wrap option that will automatically wrap the rest of the results onto the next page?

 

here is the proc report....

/******************** Test History Header ********************/
options missing=' ';

ods layout end;
ods pdf startpage=now;
ods pdf startpage=yes;
ods layout absolute x=0.0cm y=0.0cm;

%dcps_logo_page_2;


/***   Title   ***/
ods region x=3.25cm y=0.25cm;
ods pdf text="^S={font_size=14pt font_face=Calibri color=grey just=l}Duval County Public Schools Transcript";

/*** header/demographic information ***/
ods region x=3.25cm y=0.75cm;
proc report data=work.demographics split='~' missing spanrows
style(header)={font_face=Helvetica font_size=5pt height=5pt just=c vjust=m background=#D3D3D3 font_weight=bold };
column (('ID' DCPS_Student_ID)
('Student Name' student_name )
('Grade' grade_level )
('Address' address_line_1 )
('City, State Zip' address_line_2 )
('Withdrawal Status' withdraw_status));
define dcps_student_id / display '' style={cellspacing=0 cellheight=5pt just=c vjust=m font_face="Helvetica" fontsize=5pt};
define student_name / display '' style={cellspacing=0 cellheight=5pt just=c vjust=m font_face="Helvetica" fontsize=5pt};
define grade_level / display '' style={cellspacing=0 cellheight=5pt just=c vjust=m font_face="Helvetica" fontsize=5pt};
define address_line_1 / display '' style={cellspacing=0 cellheight=5pt just=c vjust=m font_face="Helvetica" fontsize=5pt};
define address_line_2 / display '' style={cellspacing=0 cellheight=5pt just=c vjust=m font_face="Helvetica" fontsize=5pt};
define withdraw_status / display '' style={cellspacing=0 cellheight=5pt just=c vjust=m font_face="Helvetica" fontsize=5pt};
run;

/*** Test History ***/
ods region x=1.0cm y=2.40cm;
proc report data=work.test_history split='~' missing spanrows
style(header)={font_face="Helvetica" font_size=5pt height=5pt just=c vjust=m background=#D3D3D3 font_weight=bold };
column ((seqno)
('Grade' grade_level)
('Test' test_date test_code test_name)
('Subject' subject_code subject_desc)
('Test Score(s)' AL SS LX PA PF RS TS));
by seqno;
define seqno / group noprint;
define grade_level / group 'Level' style={cellspacing=0 cellheight=4pt cellwidth=0.80cm just=c vjust=m font_face="Helvetica" fontsize=4pt};
define test_date / group 'Date' style={cellspacing=0 cellheight=4pt cellwidth=1.00cm just=c vjust=m font_face="Helvetica" fontsize=4pt};
define test_code / group 'Code' style={cellspacing=0 cellheight=4pt cellwidth=0.80cm just=c vjust=m font_face="Helvetica" fontsize=4pt};
define test_name / group 'Name' style={cellspacing=0 cellheight=4pt cellwidth=3.50cm just=c vjust=m font_face="Helvetica" fontsize=4pt};
define subject_code / display 'Code' style={cellspacing=0 cellheight=4pt cellwidth=0.75cm just=c vjust=m font_face="Helvetica" fontsize=4pt};
define subject_desc / display 'Description' style={cellspacing=0 cellheight=4pt cellwidth=4.50cm just=c vjust=m font_face="Helvetica" fontsize=4pt};
define AL / display 'AL' style={cellspacing=0 cellheight=4pt cellwidth=0.65cm just=c vjust=m font_face="Helvetica" fontsize=4pt};
define SS / display 'SS' style={cellspacing=0 cellheight=4pt cellwidth=0.65cm just=c vjust=m font_face="Helvetica" fontsize=4pt};
define LX / display 'LX' style={cellspacing=0 cellheight=4pt cellwidth=0.65cm just=c vjust=m font_face="Helvetica" fontsize=4pt};
define PA / display 'PA' style={cellspacing=0 cellheight=4pt cellwidth=0.65cm just=c vjust=m font_face="Helvetica" fontsize=4pt};
define PF / display 'PF' style={cellspacing=0 cellheight=4pt cellwidth=0.65cm just=c vjust=m font_face="Helvetica" fontsize=4pt};
define RS / display 'RS' style={cellspacing=0 cellheight=4pt cellwidth=0.65cm just=c vjust=m font_face="Helvetica" fontsize=4pt};
define TS / display 'TS' style={cellspacing=0 cellheight=4pt cellwidth=0.65cm just=c vjust=m font_face="Helvetica" fontsize=4pt};
compute grade_level;
if (mod(seqno,2)) then do;
call define(_col_,'style','style={background=#F5F5F5}');
end;
endcomp;
compute test_date;
if (mod(seqno,2)) then do;
call define(_col_,'style','style={background=#F5F5F5}');
end;
endcomp;
compute test_code;
if (mod(seqno,2)) then do;
call define(_col_,'style','style={background=#F5F5F5}');
end;
endcomp;
compute test_name;
if (mod(seqno,2)) then do;
call define(_col_,'style','style={background=#F5F5F5}');
end;
endcomp;
compute subject_code;
count+1;
if (mod(count,2)) then do;
call define(_col_,'style','style={background=#F5F5F5}');
end;
endcomp;
compute subject_desc;
if (mod(count,2)) then do;
call define(_col_,'style','style={background=#F5F5F5}');
end;
endcomp;
compute AL;
if (mod(count,2)) then do;
call define(_col_,'style','style={background=#F5F5F5}');
end;
endcomp;
compute SS;
if (mod(count,2)) then do;
call define(_col_,'style','style={background=#F5F5F5}');
end;
endcomp;
compute LX;
if (mod(count,2)) then do;
call define(_col_,'style','style={background=#F5F5F5}');
end;
endcomp;
compute PA;
if (mod(count,2)) then do;
call define(_col_,'style','style={background=#F5F5F5}');
end;
endcomp;
compute PF;
if (mod(count,2)) then do;
call define(_col_,'style','style={background=#F5F5F5}');
end;
endcomp;
compute RS;
if (mod(count,2)) then do;
call define(_col_,'style','style={background=#F5F5F5}');
end;
endcomp;
compute TS;
if (mod(count,2)) then do;
call define(_col_,'style','style={background=#F5F5F5}');
end;
endcomp;
title1 j=c height=6pt bold lspace=1pt 'Test History';
run;

title; /* clear graph title(s), if there is(are) one(any) from pervious iterations */
footnote; /* clear graph footnote(s), if there is(are) one(any) from pervious iterations */
ods pdf nobookmarkgen; /* this removes the -content or index- rendering once pdf is created */

PROC Star
Posts: 1,628

Re: Proc Report too long/too many rows, will not print

This has got nothing to do with graphics, hence maybe why you got no answer: You posted in the wrong location.

Having said that, I don't think that the report will span pages when you use layout.

I might be wrong though.

Ask a Question
Discussion stats
  • 1 reply
  • 126 views
  • 0 likes
  • 2 in conversation