How to produce a report with multi-layer variable information

[Miracle]

Dear All,
I am having difficult displaying the vis as the top layer of reporting.

Can I please seek you help on this?
Thanking you in advance.

Following is my proc report code.

proc report data=foo headline headskip spacing=1 split='|' formchar(2)='—' center missing nowindows;
  column vis grp ord _LABEL_ colx coly corr pval;

  define vis   / order order=internal;
  define grp       / order order=internal noprint;
  define ord       / order order=internal noprint;
  define _LABEL_   / display width=55 left "Visit| Variable|   Statistics";
  define colx      / width=15 display center "   Change in x";
  define coly     / width=15 display center "Change in y";
  define corr    / width=15 display center "Pearson coefficient" flow;
  define pval      / width=15 display center "p-value";

  break after grp / skip;

  compute before grp;   
    length text1 $110.;
    if (grp=1) then do; text1="var A"; end;
    if (grp=2) then do; text1="var B"; end;
    if (grp=3) then do; text1="var C"; end;
    if (grp=4) then do; text1="var D"; end;
    line @1 text1 $110.;  
  endcomp;

  compute before VIS;
    length text1 $110.;
    text1=put(VIS,vis_.);
  endcomp;

run;

The structure of my input data(partial) to proc report is as following.

Below is my desire report layout in rtf. I used Excel to illustrate my desired rtf layout as it is easier.

But my rtf is showing the following layout. I can't get the vis to display properly like the previous screenshot.

[ballardw]

I am very confused as to why you show what is very obviously the image of a spreadsheet and call it "rtf" output.

Please pick a way of showing desired output that you can indicate what you want and then indicate where it isn't appearing in the output you have. I'm not sure what you expect where.

I doubt that it helps to have "text1" assigned twice.

[Miracle]

Hi @ballardw 

Thanks for quick reply.
I just used the Excel to illustrate my desired rtf layout as it's easier.
I am not able to get Month 1, ..., Month n to be displayed.

For every month, I need to present statistics of every variable.

[Miracle]

I managed to get the desired output after rearranging the input data for proc report.
Thanks.