asdoc with Chinese label

[River Huang]

Dear All, How can I output the correlation matrix into Word with a "Chinese" label using (ssc install) asdoc? Please see the example

sysuse auto, clear
label var price "價格"
label var mpg "重量"
asdoc cor price mpg, label replace

The output is

Any suggestions are highly appreciated. Thanks.

[Attaullah Shah]

Since asdoc uses RTF format, the Unicode characters present a formidable task and in most cases these characters are shown as garbled text. This is one among many other reasons that I wrote asdocx, you can read the differences between asdoc and asdocx here. The example you have shown produces the following output when we use asdocx.

sysuse auto, clear
label var price "價格"
label var mpg "重量"
asdocx cor price mpg, label replace

[River Huang]

Dear Attaullah, Thanks. I have purchased the "asdocx" package. I have a problem as follows (for illustration).

sysuse auto, clear

label var price "汽車價格"
label var weight "汽車的重量"
label var length "汽車的長度"
label var rep78 "維修紀錄"
label var mpg "每小時里程數"
label var foreign "車子類型(國內外)"
label var gear_ratio "齒輪比"
label var trunk "汽車後面的行李空間"
label var displacement "車子的排氣量"

global all "price weight length rep78 mpg foreign gear_ratio trunk displacement"

asdocx cor $all, label fs(8) dec(4) save(log\T2-cor.doc) replace

The output in the Stata Results window is:

However, the output in Word is:

In my own case, I have more variables than those in the above example. Could you give some suggestions on this? Thanks.

[Attaullah Shah]

The option for font size fs() was not working correctly. I have fixed that and you can update asdocx with

asdocx_update

You may also like to use the table_layout(autofit) option to get a tight fit for contents. Here is the output from your code given above.

asdocx cor $all, label fs(8) dec(4) save(T2-cor.doc) replace table_layout(autofit)

[River Huang]

Dear Attaullah, Thanks a lot for the suggestion. I will give it a try ASAP.

[River Huang]

Dear Attaullah, Your command worked quite well. Thanks. However, another problem is the (long) name of the variable as follows.

Any suggestions?

[River Huang]

Dear Attaullah, When I ran

sysuse auto, clear
asdoc list make price mpg in 1/10, sep(0)

The output is (in Stata results window)

However, the output in the Myfile.doc is

My question is that, can I make the variable names to be centrally (or left) aligned using asdoc(x)? Thanks.

[Attaullah Shah]

Dear Professor River
If you do not want to abbreviate the lengthy lables / variable names, you can use the option abb(.) for no abbreviation at all. abb(30) will restrict the number of characters to 30.

asdocx cor $all, label fs(8) dec(4) save(log\T2-cor.doc) replace abb(.)

And for aligning variable names in the list command, I shall come up with an update later on.

[River Huang]

Dear Attaullah, Thanks a lot for the reply. I am looking forward to the update.

[Attaullah Shah]

The list command with asdocx aligns the variable names towards the left of the table cells for 2nd column and onwards and to the right for the first column. Here is an example

sysuse auto, clear
asdocx list make price mpg in 1/10, replace

[River Huang]

Dear Attaullah, Thanks. Do I need to update asdocx?

[Attaullah Shah]

Dear Prof River
No, these settings are defaults and are there from day one.

[River Huang]

Dear Attaullah, Got it and thanks.