topic Re: Proc Report in New SAS User

Proc Report

yaakov555 — Wed, 10 Aug 2022 00:38:13 GMT

How do I make a non tabular report using Proc Report?

Re: Proc Report

ballardw — Wed, 10 Aug 2022 01:43:54 GMT

Define what a "non-tabular report" would be.

Perhaps include a small example data or use of the SAS supplied data set such as Sashelp.class and show what the result is supposed to be.

Re: Proc Report

pink_poodle — Wed, 10 Aug 2022 02:43:58 GMT

You mean without the grid lines? There are various styles you can use. Please check out this gallery:
https://sassavvy.com/proc_report_gallery.html/

Re: Proc Report

yaakov555 — Wed, 10 Aug 2022 15:24:49 GMT

Hi,

This is my code

libname dat1 '~/Clinical';

%macro report(var);
Proc freq data=dat1.adsl noprint ;
tables &var*arm/ out=fsl;
Proc freq data=dat1.adsl noprint ;
tables &var/out=fsl2;
run;
data dsl;
set fsl fsl2(in=inb);
where percent ne .;
pct=cats('(',put(percent/100, percent7.2),')');
comb=catx(' ', count, pct);
if inb then
arm='Total';
run;
proc sort data=dsl out=dsl;
by &var;
run;
options validvarname=v7;
proc transpose data=dsl out=&var;
by &var;
var comb;
id arm;
run;
%mend report;

%report(sex)
%report(ethnic)
%report(race)
%report(agegr1)

data sex1;
set sex;
Array arm[8] GT0918_50_mg_day GT0918_100_mg_day GT0918_200_mg_day
GT0918_300_mg_day GT0918_400_mg_day GT0918_500_mg_day GT0918_600_mg_day total;
do i=1 to 8;
arm[i]=cats('N=',substr(arm[i],1,2));
end;
data sex;
set sex1 sex;
run;
Proc means data=dat1.adsl noprint;
var age;
class arm;
output out=arm;
format age 4.1;
run;
Proc means data=dat1.adsl noprint Median;
var age;
class arm;
output out=arm1 Median=median;
format age 4.1;
run;
data arm;
set arm arm1(rename=(median=age)) ;
by arm;
if _stat_='' then _stat_='MEDIAN';
if arm=' ' then
arm='Total';
run;
proc sort data=arm;
by _stat_;
Proc transpose data=arm out=age;
by _stat_;
var age;
id arm;
run;
data age(drop=Total GT0918_600_mg_day GT0918_500_mg_day GT0918_50_mg_day
GT0918_400_mg_day GT0918_300_mg_day GT0918_200_mg_day GT0918_100_mg_day);
set age;
total1=put(total, 5.1);
g_100=put(GT0918_100_mg_day, 5.1);
g_200=put(GT0918_200_mg_day, 5.1);
g_300=put(GT0918_300_mg_day, 5.1);
g_400=put(GT0918_400_mg_day, 5.1);
g_50=put(GT0918_50_mg_day, 5.1);
g_500=put(GT0918_500_mg_day, 5.1);
g_600=put(GT0918_600_mg_day, 5.1);
run;
data rep(drop=_name_ sex ethnic race agegr1 i);
length Parameter $25 Category $25 sex $4;
set sex ethnic race age(rename=(total1=total g_100=GT0918_100_mg_day
g_200=GT0918_200_mg_day g_300=GT0918_300_mg_day g_400=GT0918_400_mg_day
g_50=GT0918_50_mg_day g_500=GT0918_500_mg_day g_600=GT0918_600_mg_day
_label_=Parameter _stat_=Category)) agegr1;
Array arm[7] GT0918_50_mg_day GT0918_100_mg_day GT0918_200_mg_day
GT0918_300_mg_day GT0918_400_mg_day GT0918_500_mg_day GT0918_600_mg_day;
do i=1 to 7;
if arm[i]=' ' then
arm[i]='0 (0.00%)';
end;
if sex='M' then
sex='Male';
if sex ='Male' and _n_>1 then
do;
Parameter='Sex';
Category=sex;
end;
if ethnic ne ' ' then
do;
Parameter='Ethnicity';
Category=ethnic;
end;
if race ne ' ' then
do;
Parameter='Race';
Category=race;
end;
if agegr1 ne ' ' then
do;
Parameter='Age Group (Years)';
Category=agegr1;
end;
if Parameter='Age' then
Parameter='Age (Years)';
run;
Title 'Table 12.1.2.1.1';
Title2 'Demographic Characteristics';
Title3 'Safety Analysis Set';
proc report data=rep split='~' missing ;
columns (Parameter Category ('Escalation Cohort' GT0918_50_mg_day GT0918_100_mg_day
GT0918_200_mg_day GT0918_300_mg_day GT0918_400_mg_day
GT0918_500_mg_day GT0918_600_mg_day)('Total' Total));
Define Parameter/group order=data 'Parameter' ;
Define Category/group 'Category/~Statistic' left;
Define GT0918_50_mg_day / 'GT0918~50 mg/day' center ;
Define GT0918_100_mg_day/ 'GT0918~100 mg/day' center;
Define GT0918_200_mg_day/ 'GT0918~200 mg/day' center;
Define GT0918_300_mg_day/ 'GT0918~300 mg/day' center;
Define GT0918_400_mg_day/ 'GT0918~400 mg/day' center;
Define GT0918_500_mg_day/ 'GT0918~500 mg/day' center;
Define GT0918_600_mg_day/ 'GT0918~600 mg/day' center;
Define Total/'' center;
compute after Parameter;
line ' ';
Endcomp;
run;

In the output window the results are in tabular format and the headings appear in blue. I need to get rid of all that.

FYI: I am using SAS Studio.

Re: Proc Report

yaakov555 — Wed, 10 Aug 2022 15:54:42 GMT

Yes how do I get rid of the grid lines?

Re: Proc Report

Reeza — Wed, 10 Aug 2022 15:59:00 GMT

Display of a report is controlled by both the STYLE default and the settings in proc report.

Look at the different SAS styles and consider changing your ODS STYLE as a starting point. Look at the Journal Style for a very basic style.

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/odsadvug/p14qidvs5xf7omn14ommvsuhvmzn.htm#p1m9ucfbtt5mbwn15vmh6hmx1qv0

Re: Proc Report

yaakov555 — Wed, 10 Aug 2022 17:02:50 GMT

Is it not possible to create a report without any grid?

Re: Proc Report

Reeza — Wed, 10 Aug 2022 17:25:24 GMT

Yes, but you may need to specify how.

Re: Proc Report

Tom — Wed, 10 Aug 2022 17:27:24 GMT

@yaakov555 wrote:

Is it not possible to create a report without any grid?

Sure it is. What did you TRY?

Why not just make them "invisible" by using the same color as the background?

proc report data=sashelp.class 
  style(column)=[bordercolor=white] 
  style(header)=[bordercolor=white] 
;
run;

Re: Proc Report

yaakov555 — Wed, 10 Aug 2022 17:33:24 GMT

I would like it the way proc report used to do it, without any grid.

Re: Proc Report

Reeza — Wed, 10 Aug 2022 18:10:49 GMT

SASDocPrinter Style is the one you want, I suspect. It's in the list I previously linked to.

ods pdf file='/home/fkhurshed/Demo1/pdf_example.pdf' style=sasdocprinter;

proc report data=sashelp.class;
run;

ods pdf close;

Re: Proc Report

yaakov555 — Sun, 14 Aug 2022 18:54:53 GMT

This is better but I am still not there

Re: Proc Report

Cynthia_sas — Mon, 15 Aug 2022 00:18:50 GMT

Hi:

Your code needs to take full control of the ODS destination. It looks like you are using the default ODS HTML destination. Most of the demographic reports like this that I see are created for RTF and/or PDF output, not HTML. but in any case, you need full control so that you can control the destination and the style being used. In addition, I used some simple ODS style overrides in the PROC REPORT code to turn off the grid lines. Rather than run your code over and over again, I just made a CSV file for WORK.REP and used that. Changes to your code are highlighted in yellow:

All the output is shown below:

Cynthia