[Ross]

in reply to: Bug with Regression Labels on Categorical Variables #18577

Actually, I just noted your output has “base” and not “(Reference:” before the category label anbd after the variable label. I wonder why that is?

My regression syntax is like this.

asdocx regress V1 V2 ///
	$x_cont_controls $x_fact_controls,  ///
	replace nest ///
	rep(p) save($export_folder\temp_reg01.doc) title(`reg1') dec(2) abb(.) fs(8) label 
	
asdocx regress V3 V2 ///
	$x_cont_controls $x_fact_controls,  ///
	nest ///
	rep(p) save($export_folder\temp_reg01) title(`reg1') dec(2) stat(r2_a) abb(.) fs(8) label

[Ross]

in reply to: Bug with Regression Labels on Categorical Variables #18576

Thank you Dr. Shah, but the issue is a bit different. Actually I have 2 issues.
1) It is basically that the base (aka reference) generated text is being assigned to the wrong label. So the generated text “Reference: )” is appearing on the 1st category and not the one I assign as the base for the regression.

So I am getting using the above example, I receive “Fund Strategy Categories, From Raw Data (Reference: Micro Cap)” on Micro, which is not the base I set with the syntax, it should be assigned to Small Cap

global x_fact_controls ///	
    ib(2).cat_Fund_Strategy  ///  // Base: [02] Small Cap

Said differently, the text “(Reference: )” should move from the 1st label to the 2nd label “Small Cap.” Actually, I rather like the label before the categories “Fund Strategy Categories, From Raw Data” if it can stay that would be great!

2) there is spacing in the docx output sometimes and sometimes not on the individual variables/labels. It seems to only happen on variables that I have which are dummies and the values are either 0 or 1.

COVID-19 Recession (2020)

New Normal, Post-Pandemic Economy (2021-2024)

Dummy indicator if fund is the first-time fund of the PE firm (Reference: Not first-time fund)

Yes a first-time fund

Dummy Indicator If Fund Is Completed (Reference: Unrealized Fund)

Also the 1st part of the dummy variables was always cutoff, but I came up with a fix by adding some characters before.

Syntax:
gen d_first_time_fund = 0
replace d_first_time_fund = 1 if Fund_Generation_Sequence == 1
label variable d_first_time_fund "Dummy indicator if fund is the first-time fund of the PE firm"
label define first_time_fund_lbl 0 "0 Not first-time fund" 1 "1 Yes a first-time fund"
label values d_first_time_fund first_time_fund_lbl

[Author]

Posts