RWI listing

analyst_work — Thu, 09 Jun 2016 20:47:37 GMT

Hi,

I want to write a code for the following listing using RWI:

Group Name Age Sex

grp1 n1 a1 s1

n2 a2 s2

n3 a3 s3

grp2 n4 a4 s4

n5 a5 s5

I am getting the output, however, the grp variable is repeating for all observations, whereas I want it only for the first observation in the group.

Re: RWI listing

Cynthia_sas — Fri, 10 Jun 2016 20:34:34 GMT

Hi,

Have you tried BY group processing... so that your row for every obs would be something like this:

  ** row for every obs;
      obj.row_start(); 
        if first.byvar then obj.format_cell(data: byvar ); 
	  else obj.format_cell(text: " ");
        obj.format_cell(data: var2); 
        obj.format_cell(data: var3); 
        . . . more code for more variables . . .
        obj.format_cell(data: var??); 
 
      obj.row_end();

You would need to make sure that the data was in order and you had a BY statement in your DATA step program.

cynthia

topic RWI listing in ODS and Base Reporting

RWI listing

Re: RWI listing