Issue on repeat ORDER variable values that span multiple pages in tagsets.rtf ?

[Nalla]

Hi team,

I just mock the output (ATTACHED) I am getting in my original statistical reports. @ SAS 9.3.

The issue is,

Even after giving UNIFORM option and SPANROWS in Proc Report,

In the below code these are the following scenarios happening:

• In page 2 of output, sex variable value is not repeating in the beginning line.
• In page 3 & 4, both sex and age are not repeating in the beginning line.

Data class;

  set sashelp.class;

  do i = 1 to 5;

  output;

  end;

run;

options nodate nonumber center nobyline;

ods listing close;

ods tagsets.rtf file='class.rtf' uniform options(doc="Help");

title1 "Title dummy 1";

title2 "Title dummy 2";

Footnote1 "Footnote dummy 1";

Footnote2 "Footnote dummy 2";

proc report data=class nowindows spanrows;

  column sex age name height weight;

  define sex / order order = internal;

  define age / order order = internal;

  define name / order order = internal;

  define height / display;

  define weight / display;

  break after name / summarize suppress;

run;

ods tagsets.rtf close;

In order to get sex & age in all the pages what should be done on this code.

There should be a skip after each "Name" variable value  as represented. Please advice.

Thanks,

Nalla

[Nalla]

Guys, Please have a look on above issue

[Cynthia_sas]

Hi:

  If you have the need for an immediate resolution or urgent help, your best resource is to open a track with Tech Support. Also, if you search support.sas.com for previous notes, I think this one is the relevant note http://supportprod.unx.sas.com/kb/53/783.html and I know that there have been previous forum postings on the same topic/issue.

cynthia