bill is almost right, you do not use the size() option directly. Instead, you specify the bubble size as the third positional argument.

sysuse auto, clear
gen weight2 = sqrt(weight)
twoway bubble price mpg weight2