RWI listing

[analyst_work]

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.

[Cynthia_sas · Accepted solution]

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