BookmarkSubscribeRSS Feed
Nalla
Calcite | Level 5

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

2 REPLIES 2
Nalla
Calcite | Level 5

Guys, Please have a look on above issue

Cynthia_sas
SAS Super FREQ

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 2 replies
  • 1087 views
  • 0 likes
  • 2 in conversation