In your code, you never close the listing destination. If you only want the PROC MEANS results to print to the listing, you need to close the listing destination before your first PROC REG, then before each PROC MEANS step open the listing destination, and after the PROC MEANS step close the listing destination. You could do that like:
ods _all_ close;
proc sort data=FINAL out=FM_quadric_reg_adj_ebxi_a;
by GVKEY01 Full_Name;
run;
PROC REG DATA=FM_quadric_reg_adj_ebxi_a
outest=FM_quadric_reg_adj_ebxi3 noprint outseb;
MODEL Adj_m1_e_bxi_a /*EM tobin_q */= /*ln_year_of_tenure*/ Year_of_Tenure year_of_tenure2;
by GVKEY01 Full_Name;
RUN;
QUIT;
proc sql;
create table FM_quadric_reg_adj_ebxi3_PARMS as
select *
from FM_quadric_reg_adj_ebxi3
where _type_ = "PARMS";
data FM_quadric_reg_adj_ebxi3_PARMS2;
set FM_quadric_reg_adj_ebxi3_PARMS;
drop _type_;
run;
proc summary data=FM_quadric_reg_adj_ebxi3_PARMS2;
var intercept /*ln_year_of_tenure */Year_of_Tenure year_of_tenure2;
output out=FM_quadric_reg_adj_ebxi3_summ p5= p95= / autoname;
quit;
data FM_quadric_reg_adj_ebxi3_Winz;
set FM_quadric_reg_adj_ebxi3_PARMS2;
if _n_ = 1 then set
FM_quadric_reg_adj_ebxi3_summ;
intercept_winz = min(max(intercept, intercept_p5), intercept_p95);
Year_of_Tenure_winz = min(max(Year_of_Tenure, Year_of_Tenure_p5), Year_of_Tenure_p95);
year_of_tenure2_winz = min(max(year_of_tenure2, year_of_tenure2_p5), year_of_tenure2_p95);
run;
ods listing;
proc means data=FM_quadric_reg_adj_ebxi3_Winz n mean t probt stderr;
run;
ods listing close;
PROC REG DATA=FM_quadric_reg_adj_ebxi_a
outest=FM_quadric_reg_adj_ebxi2 noprint outseb;
MODEL Adj_m1_e_bxi_a /*EM tobin_q*/ = Year_of_Tenure year_of_tenure2;
by GVKEY01 Full_Name;
RUN;
QUIT;
proc sql;
create table FM_quadric_reg_adj_ebxi2_PARMS as
select *
from FM_quadric_reg_adj_ebxi2
where _type_ = "PARMS";
data FM_quadric_reg_adj_ebxi2_PARMS2;
set FM_quadric_reg_adj_ebxi2_PARMS;
drop _type_;
run;
proc summary data=FM_quadric_reg_adj_ebxi2_PARMS2;
var intercept Year_of_Tenure year_of_tenure2;
output out=FM_quadric_reg_adj_ebxi2_summ p5= p95= / autoname;
quit;
data FM_quadric_reg_adj_ebxi2_Winz;
set FM_quadric_reg_adj_ebxi2_PARMS2;
if _n_ = 1 then set
FM_quadric_reg_adj_ebxi2_summ;
intercept_winz = min(max(intercept, intercept_p5), intercept_p95);
Year_of_Tenure_winz = min(max(Year_of_Tenure, Year_of_Tenure_p5), Year_of_Tenure_p95);
year_of_tenure2_winz = min(max(year_of_tenure2, year_of_tenure2_p5), year_of_tenure2_p95);
run;
ods listing;
proc means data=FM_quadric_reg_adj_ebxi2_Winz n mean t probt stderr;
run;
ods listing close;
proc sort data=FINAL out= cl_adj_ebxi1_a_fm;
by GVKEY01 Full_Name 'Data Year - Fiscal'n ;
RUN;
PROC REG data=cl_adj_ebxi1_a_fm
outest=cl_adj_ebxi1_a noprint outseb;
model Adj_m1_e_bxi_a /*EM/* tobin_q */= year_of_tenure DM_ebxi_X DM_adj_ebxi_a;
by GVKEY01 Full_Name;
run;
quit;
proc sql;
create table cl_adj_ebxi1_a_PARMS as
select *
from cl_adj_ebxi1_a
where _type_ = "PARMS";
data cl_adj_ebxi1_a_PARMS2;
set cl_adj_ebxi1_a_PARMS;
drop _type_;
run;
proc summary data=cl_adj_ebxi1_a_PARMS2;
var intercept year_of_tenure DM_ebxi_X DM_adj_ebxi_a;
output out=cl_adj_ebxi1_a_summ p5= p95= / autoname;
quit;
data cl_adj_ebxi1_a_Winz;
set cl_adj_ebxi1_a_PARMS2;
if _n_ = 1 then set
cl_adj_ebxi1_a_summ;
intercept_winz = min(max(intercept, intercept_p5), intercept_p95);
Year_of_Tenure_winz = min(max(Year_of_Tenure, Year_of_Tenure_p5), Year_of_Tenure_p95);
DM_ebxi_X_winz = min(max(DM_ebxi_X, DM_ebxi_X_p5), DM_ebxi_X_p95);
DM_adj_ebxi_a_winz = min(max(DM_adj_ebxi_a, DM_adj_ebxi_a_p5), DM_adj_ebxi_a_p95);
run;
ods listing;
proc means data=cl_adj_ebxi1_a_Winz n mean t probt;
run;
ods listing close;
proc sort data=FINAL out= cl_adj_ebxi2_a_fm;
by GVKEY01 Full_Name 'Data Year - Fiscal'n ;
PROC REG data=cl_adj_ebxi2_a_fm
outest=cl_adj_ebxi2_a noprint outseb;
model Adj_m1_e_bxi_a /*EM /*tobin_q*/=year_of_tenure DM_ebxi_X DM_adj_ebxi_a;
by GVKEY01 Full_Name;
un;
quit;
proc sql;
create table cl_adj_ebxi2_a_PARMS as
select *
from cl_adj_ebxi2_a
where _type_ = "PARMS";
data cl_adj_ebxi2_a_PARMS2;
set cl_adj_ebxi2_a_PARMS;
drop _type_;
run;
proc summary data=cl_adj_ebxi2_a_PARMS2;
var intercept year_of_tenure DM_ebxi_X DM_adj_ebxi_a;
output out=cl_adj_ebxi2_a_summ p5= p95= / autoname;
quit;
data cl_adj_ebxi2_a_Winz;
set cl_adj_ebxi2_a_PARMS2;
if _n_ = 1 then set
cl_adj_ebxi2_a_summ;
intercept_winz = min(max(intercept, intercept_p5), intercept_p95);
Year_of_Tenure_winz = min(max(Year_of_Tenure, Year_of_Tenure_p5), Year_of_Tenure_p95);
DM_ebxi_X_winz = min(max(DM_ebxi_X, DM_ebxi_X_p5), DM_ebxi_X_p95);
DM_adj_ebxi_a_winz = min(max(DM_adj_ebxi_a, DM_adj_ebxi_a_p5), DM_adj_ebxi_a_p95);
ods listing;
proc means data=cl_adj_ebxi2_a_Winz n mean t probt;
run;
... View more
