Hello,
I am looking for a way equivalent to SPSS (AGGREGATE with PIN) syntax
I have data
id zipcode race
1 11364 white
2 11364 black
3 98006 white
4 98006 asian
Then, I want to have
zipcode count asian black white
11364 2 0% 50% 50%
98006 2 50% 0% 50%
Can anyone please have an idea how to get this?
Thank you,
Related Posts with Aggregating and percentage distribution simultaneously
Interpretation Climatic AnomaliesHello, I am having a question regarding the interpretation of a variable in my regression. I have p…
Generate share of number of firms in panel dataHi, I would like to generate a table which shows share of number of firms (percentage of number of …
Generate age in paneldataHi I have already the birthday but I will like to create a birth-year. How can I do that? …
Irrational results from xtabond2- two step system GMM log-linear modelHi all, I am running xtabond2 on the model , and the command is: xtabond2 lVal l.lVal l(0/5).Init_a…
Times series plotHi, I’m trying to create a time series plot with the data below. I´m trying to create one plot for …
Subscribe to:
Post Comments (Atom)
0 Response to Aggregating and percentage distribution simultaneously
Post a Comment