Hi,
I have a panel data set where i have variables "location"(where number 1 means one location, 2 another one ans so on) , "sales" numbers in dollar, and year.
i want this for example to work: total sales if location ==1 / total sales
what do i do wrong here? stata does not want to devide things if it is not variables and total sales is one value generated by summarizing all the sales and total sales if location ==1 is an estracted value(total). i want to do this for all locations.
how can i come around this?
it would be helpful if you know how to solve this problem in a table if it is possible as i would want to do it on all locations and se how big the percentage sales of each location is on the total sales of the whole dataset
Related Posts with divide numbers in stata
Graph two slopes from grouped xtregressionHello, I would like to graph the two coefficient slopes I obtained from my xtreg command. This is m…
tabstast: How to display the highest values in a single table?Dear Statalist, I would like to make a table that shows the frequency of the 2 highest sales in the…
[HELP] Appending several CSV files togetherHello Statalist, Currently trying to append several CSV files into one on Stata (I understand the r…
Marginal structural models and Multivariate regressionIf we get similar estimates of multivariate regression compared with marginal structural models (MSM…
Determining whether to include a squared term and maximizationSay I have coffee = beta0 + beta1educ + beta2imptax + beta3ln(income) + beta4age + beta5agesq + u Wh…
Subscribe to:
Post Comments (Atom)
0 Response to divide numbers in stata
Post a Comment