Putexcel using proportions

[Vanessa Cox]

I am having trouble exporting my results using putexcel, and seem to always get this error "option modify not allowed". Does anyone know why? I'm running STATA 14.1 on Windows 8.1 Pro. Here is a sample program:
sysuse auto, clear
prop rep78, over(gear_ratio)
matrix X3 = r(table)
putexcel set "j", sheet("a") modify
matrix list X3
putexcel X3, modify

Thanks in advance for any help.
Vanessa

[Niels Henrik Bruun]

First of all this is Mata forum, your question is in Stata so it is missplaced.
But the answer is that putexcel has changed from 13.1 to 14.1, so what you have to do is to try

help putexcel

.
Use ctrl+f to find modify in the help text.
Then you see how to do it