I am trying to report the results of my regression analysis in a Journal quality format, the usual format that is used to show the results of regressions should something like this, with estimates for different models in separate columns, significance level reported by * and stddev reported in the parentheses below each estimation : The results of the regression are not reported like this the SAS output, so I combine my results from different output tables and get a dataset like this: I used proc report to put the output in publication quality format, that is my code: ODS ESCAPECHAR='^';
ods pdf file='inddind_drugNEW.pdf' style=journal2 notoc;
proc report data=combinedrugY( rename=(stderr=std1 ProbChiSq =pb1)) out=temptbl ;
column variable model ,(pb1 estimate std1);
define variable/group order=data ' ';
define model/ across ' ';
define pb1 /noprint sum ;
define estimate /analysis sum ' ';
define std1 /analysis sum format=stderrf. ' ' ;
compute estimate ;
array cc _c11_ _c8_ _c5_ _c2_;
do i= 1 to 4 ;
if ~missing(cc(i)) then do;
if 0.05<cc(i) <= 0.1 then call define(_col_, "style", "style=[ posttext='*']" );
else if 0.01 <cc(i) <=0.05 then call define(_col_, "style", "style=[ posttext='**']" );
else if cc(i) <= 0.01 then call define(_col_, "style", "style=[ posttext='***']" );
leave;end;
end;
endcomp;
run;
ods text="^S={width=100% just=c } NOTE: Logit regression for probability of an individual diagnosed with abuse or addiction of different substances, all specifications control for year and state and fixed effects. ^{newline}
^S={just=l }*** Significant at the 1 percent level. ^{newline}
** Significant at the 5 percent level. ^{newline}
* Significant at the 10 percent level. ^{newline} " ;
ods pdf close;title;footnote; The output looks like this: As you can see, it is still is not in the format I was hopping. It would be great if someone would help me to fix the table so that: 1) put the stdd1 under the estimate variable instead of beside it. 2) Adjust the Note text such that it starts at the point that table starts instead of the start of the line. Thank you.
... View more