PROC REPORT has no errors, but not printing

[mariko5797]

I see no errors in my SAS log, but the output is just a blank document that is "Read Only"?? I am not sure where the Read Only part comes from since I am the one who created this document and have had zero problem with other table documents.

The latter may be a different problem. My main issue is that no results are being displayed. Below is a snippet of my log file.

362  /* ------------------------------------------------------------- Table 19
362! ------------------------------------------------------------- */
363  data tab19;
364   set stresults;
365   where SPECTYPE = 'BREAST MILK';
366   if PER_1 ^= . | PER_2 ^= . then output;
367  run;

NOTE: There were 30 observations read from the data set WORK.STRESULTS.
      WHERE SPECTYPE='BREAST MILK';
NOTE: The data set WORK.TAB19 has 18 observations and 10 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.03 seconds


368
369  %let w = 0.6in;
370
371  title; footnote;
372
373  ods listing close; ods html close;
374  options orientation = portrait;
375  ods escapechar = '^';
376  ods rtf file = 'G:\VID\ANTIMICROBIALS\STAT\160076\24_Final
376! Reports\Tables\Tab_summ_stat_azi_breastmilk.rtf' bodytitle;
NOTE: Writing RTF Body file: G:\VID\ANTIMICROBIALS\STAT\160076\24_Final
      Reports\Tables\Tab_summ_stat_azi_breastmilk.rtf
377  title1 h = 12pt f = 'Times New Roman' j = left bold "Summary Statistics for Azithromycin
377! Concentrations in Breast Milk by Obesity Status";
378
379  proc report data = tab19 nowd split = '*'
380   %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";
381
382   column BMI STAT PER_1 PER_2 PER_4;
383
384   define BMI / order display 'BMI' format = BMI. style(column) = [just = left cellwidth =
384! 0.75in];
385   define STAT / display 'Statistic' format = STAT. style(column) = [just = left cellwidth =
385! 0.75in];
386   define PER_1 / display '0-<12 hours Post Start of Infusion' style(column) = [just = left
386! cellwidth = &w];
387   define PER_2 / display '12-<24 hours Post Start of Infusion' style(column) = [just = left
387! cellwidth = &w];
388   define PER_4 / display 'Any Time Post Start of Infusion' style(column) = [just = left
388! cellwidth = &w];
389
390   compute after _page_/left;
391    line "Note: If more than one sample collected per time period, the mean breast milk
391! concentration by subject was summarized. The p-value is for a [insert test type] comparing
391! concentrations by obesity status and is only
392     computed if > 3subjects have a concentration within the time period for each group.";
NOTE: The quoted string currently being processed has become more than 262 characters long.  You
      might have unbalanced quotation marks.
393   endcomp;
394
395  run;

NOTE: The quoted string currently being processed has become more than 262 characters long.  You
      might have unbalanced quotation marks.
NOTE: There were 18 observations read from the data set WORK.TAB19.
NOTE: PROCEDURE REPORT used (Total process time):
      real time           0.10 seconds
      cpu time            0.07 seconds

[ballardw · Accepted solution]

You don't show an

Ods rtf close;

The file won't be completed until that is submitted.

[mariko5797]

It was so obvious.... Thank you 

[ballardw]

Having been bitten by this a few times I often do the ODS destination and close first. Then stick the code creating output in between.

[Cynthia_sas]

Hi:
You typically get a read-only message from Word or Excel if SAS is still holding the file open for write access. So if you've forgotten to close the ODS destination, you could get that message. You showed most of your log but didn't show the ODS RTF CLOSE, as already noted.

Cynthia