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
You don't show an
Ods rtf close;
The file won't be completed until that is submitted.
You don't show an
Ods rtf close;
The file won't be completed until that is submitted.
It was so obvious.... Thank you
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.
Find more tutorials on the SAS Users YouTube channel.