The SAS Output Delivery System and reporting techniques

RWI listing

Accepted Solution Solved
Reply
Contributor
Posts: 21
Accepted Solution

RWI listing

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.

  


Accepted Solutions
Solution
‎06-13-2016 10:15 AM
SAS Super FREQ
Posts: 8,719

Re: RWI listing

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

View solution in original post


All Replies
Solution
‎06-13-2016 10:15 AM
SAS Super FREQ
Posts: 8,719

Re: RWI listing

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 204 views
  • 1 like
  • 2 in conversation