topic Re: How to produce a report with multi-layer variable information in SAS Procedures

How to produce a report with multi-layer variable information

Miracle — Sat, 24 Oct 2020 08:35:32 GMT

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.

Re: How to produce a report with multi-layer variable information

ballardw — Sat, 24 Oct 2020 08:10:07 GMT

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.

Re: How to produce a report with multi-layer variable information

Miracle — Sat, 24 Oct 2020 08:22:46 GMT

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.

Re: How to produce a report with multi-layer variable information

Miracle — Sat, 24 Oct 2020 15:52:36 GMT

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