Hi,
I receive more output than I want.
Here are the four different codes for regressions, which are included in the program:
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;
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;
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;
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;
run;
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
