BookmarkSubscribeRSS Feed
smilbuta
Fluorite | Level 6
Hello community ,

I have a problem,

I am creating a report and am attempting to use the Break function..
here is my code:


title1 'Fall 2010 to fall 2009 Comparison Report';

proc report data=Work.append_table nowd;
column new_returning student_type report_Date,type_count;
define new_returning / group 'Registration Type';
define type_count / analysis '__________';
define student_type /group 'Student Type';
define Report_Date /across format=date9. 'Report Date';
break after new_returning /summarize suppress skip; PROBLEM
run;


Problem, the arguments summarize and suppress function accordingly here but skip fails to insert a blank row.

I have even attempted the following:

break after new_returning /skip;

with no success. I am using EG 4.1 and this is a code block in my project.
3 REPLIES 3
Cynthia_sas
SAS Super FREQ
Hi:
By default, Enterprise Guide uses ODS HTML to show you results. The SKIP option, however, does not work for ODS HTML. It is one of a set options that are LISTING-only (SKIP, DOL, DUL, OL, UL, HEADLINE, HEADSKIP, FLOW, PANELS, SPACE, WIDTH, etc) and so, within the context of EG and the default HTML output from EG -- you may as well not use these options.

In addition to not using the SKIP option from inside EG, you may find that your line of underscores does not product the output you want.

To insert a blank line between logical groups of observations, use a COMPUTE block:
[pre]
break after new_returning /summarize suppress;
compute after new_returning;
line ' ';
endcomp;
[/pre]

Other PROC REPORT options are also LISTING options, such as BOX, COLWIDTH, FORMCHAR, SPACING, PSPACE and DEFINE and BREAK statement options such as: FLOW, WIDTH, DOL, DUL, OL, UL, For more information about the fact that these LISTING-only options do not work with other ODS destinations, see this Tech Support note:
http://support.sas.com/kb/2/549.html
and this "workaround" example code for how to simulate some of the options (mostly using CSS style properties):
http://support.sas.com/rnd/base/ods/templateFAQ/report1.html

cynthia
smilbuta
Fluorite | Level 6
Thank you.
I am using Carpenters Complete guide to SAS PROC Reporting it does not explains this issue to new users.

The only environment i have to work in is EG.

THanks again for the information.
Cynthia_sas
SAS Super FREQ
Hi:
That is an excellent PROC REPORT resource. I believe that when Art talks about ODS, he does eventually mention that some options are LISTING only options. The consequences of this behavior might not be immediately apparent to Enterprise Guide users, however, since Enterprise Guide "hides" all ODS code from EG users.

I'm glad I was able to clarify the issue for you.

cynthia

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1838 views
  • 0 likes
  • 2 in conversation