PROC REPORT not outputting to RTF

[mariko5797]

As the subject title suggests, I am having issues getting my table to output in an RTF file. The only thing that outputs is the title given. Any ideas as to where the problem lies? Thank you in advance!

data test;
 input ordb bmi $ ords stat $ _1 _2 _3 _4 @@;
 cards;
 1 Obese 1 N 	2 3 4 5
 1 Obese 2 DV 	2 3 4 5
 2 NotOb 1 N	2 3 4 5
 2 NotOb 2 DV	2 3 4 5
 3 SevOb 1 N	2 3 4 5
 3 SevOb 2 DV	2 3 4 5
 4 Comp	 3 P	0.1 . . 0.02
 ;
run;

	ods rtf file = "G:\VID\ANTIMICROBIALS\STAT\160076\24_Final Reports\Tables\Tab_summ_stats_test.rtf" style = work.CSR_rtf_portrait;
	ods rtf startpage = yes text = "^S = {cellwidth = 6.5in just = l fontsize = 12pt fontweight = bold}Testing Data";

	proc report data = test nowd split = '*'
	 %reportStyle;

			column ("^S = {borderbottomcolor = white}" ordb bmi) ("^S = {borderbottomcolor = white}" ords stat)("Time Post Start of Infusion" _1 _2 _3 _4); 

			define ordb	/ order noprint;
			define bmi 	/ display "BMI";
			define ords	/ order noprint;
			define stat	/ display "Statistic";
			define _1 	/ display "0-<12 hours";
			define _2	/ display "12-<24 hours";
			define _3	/ display "24-<48 hours";
			define _4	/ display "48+ hours";

	 compute after;
	 	line "Note: If more than one sample collected per time period, the mean plasma concentration by subject was summarized. The p-value is for an ANOVA comparing concentrations by obesity status
	 and is only computed if >3 subjects have a concentration within the time period for at least two groups.";
		line 'Note: Concentrations were adjusted for dose received at time sample taken.';
	 endcomp;

	run;

	ods rtf close;

The report style and template used are outlined below:

proc template;
	*define style styles.CSR_rtf_portrait;
	define style work.CSR_rtf_portrait;
	parent=styles.rtf;
	style body from document /
		leftmargin=0.75in
		rightmargin=0.38in
		topmargin=0.38in
		bottommargin=0.38in;
	end;
run;

%macro reportStyle;
	style(report)=[just=center cellspacing=1 font_face="times new roman" font_size=9pt outputwidth=100%]
	style(header)=[just=center font_size=2 background=white foreground=black font_face="times new roman" font_size=9pt]
	style(column)=[just=center font_size=2 background=white just=center font_face="times new roman" font_size=9pt]
	style(lines)=[font_size=2 background=white just=left font_face="times new roman" font_size=9pt];
	footnote j=c h=12pt color=red bold "CONFIDENTIAL";
%mend;

The log file has no warnings or errors

1596      ods rtf file = "G:\VID\ANTIMICROBIALS\STAT\160076\24_Final Reports\Tables\Tab_summ_stats_test.rtf" style =
1596! work.CSR_rtf_portrait;
NOTE: Writing RTF Body file: G:\VID\ANTIMICROBIALS\STAT\160076\24_Final Reports\Tables\Tab_summ_stats_test.rtf
1597      ods rtf startpage = yes text = "^S = {cellwidth = 6.5in just = l fontsize = 12pt fontweight = bold}Testing Data";
1598
1599      proc report data = test nowd split = '*'
1600       %reportStyle;
MPRINT(REPORTSTYLE):   style(report)=[just=center cellspacing=1 font_face="times new roman" font_size=9pt outputwidth=100%]
style(header)=[just=center font_size=2 background=white foreground=black font_face="times new roman" font_size=9pt]
style(column)=[just=center font_size=2 background=white just=center font_face="times new roman" font_size=9pt]
style(lines)=[font_size=2 background=white just=left font_face="times new roman" font_size=9pt];
MPRINT(REPORTSTYLE):   footnote j=c h=12pt color=red bold "CONFIDENTIAL";
1601
1602              column ("^S = {borderbottomcolor = white}" ordb bmi) ("^S = {borderbottomcolor = white}" ords stat)("Time Post Start
1602!  of Infusion" _1 _2 _3 _4);
1603
1604              define ordb / order noprint;
1605              define bmi  / display "BMI";
1606              define ords / order noprint;
1607              define stat / display "Statistic";
1608              define _1   / display "0-<12 hours";
1609              define _2   / display "12-<24 hours";
1610              define _3   / display "24-<48 hours";
1611              define _4   / display "48+ hours";
1612
1613       compute after;
1614          line "Note: If more than one sample collected per time period, the mean plasma concentration by subject was summarized.
1614! The p-value is for an ANOVA comparing concentrations by obesity status
1615       and is only computed if >3 subjects have a concentration within the time period for at least two groups.";
NOTE: The quoted string currently being processed has become more than 262 characters long.  You might have unbalanced quotation
      marks.
1616          line 'Note: Concentrations were adjusted for dose received at time sample taken.';
1617       endcomp;
1618
1619      run;

NOTE: There were 7 observations read from the data set WORK.TEST.
NOTE: PROCEDURE REPORT used (Total process time):
      real time           0.05 seconds
      cpu time            0.01 seconds


1620
1621      ods rtf close;

[Ksharp]

I tested your code , and get no problem .
Do you check the path "G:\VID\ANTIMICROBIALS\STAT\160076\24_Final Reports\Tables\Tab_summ_stats_test.rtf" ?
if there is a rtf file "Tab_summ_stats_test.rtf" ?

[mariko5797]

There is a RTF file in the proper folder. It only contains the title and footnote though. I tried changing the pathway to my desktop and still have the same issue.

[Kurt_Bremser]

Look at the timestamp of the file in Windows Explorer.

[mariko5797]

Time stamp 2/4/2022 8:51 AM

[Kurt_Bremser]

If your SAS runs on a server, it may have a different device as drive G than your desktop.

[mariko5797]

Mentioned in my reply to @Ksharp: I tried changing the pathway to see if that may be part of the issue, but it didn't help. There is a document with the proper title in G drive folder and when I tried saving to my desktop, but only the title and footnote appear. I am running SAS 9.4 TS Level 1M7, if that makes any difference at all.

[mariko5797 · Accepted solution]

Figured it out: ODS EXCLUDE ALL was written earlier in the original code, so anything ran after that would not appear.