Hello, I am using YRBS data -- a student survey taken in each US state every other year. Each entry of my dataset contains the responses of each individual student, along with the state and year. I want to create a time trend for a dummy variable--that is: how many students (more specifically, what percentage of them) in state A, B, C, etc. responded Yes to the question in each of the years X Y C.
I can find this easily by creating a for loop for each state and then tabulating year and the question (I should add that I weight the tabulations). However, this is not useful for my end goal, which is to handle a time trend.
How can I collapse this variable (a dummy variable with weights for each individual), to get the pct of students each year, for each state, that replied "yes"?
I have tried collapse, tabout, table, tabstat, tab2xl, etc. -- and can't quite get what I want.
Thank you!
Related Posts with Weighted Tabulation by Multiple Groups -- Export to XLS or DTA
Division into two groupsDear statalists, I am running an analysis with an unbalanced dataset for 10 years. I would like to …
Clustered Errors and fixed effect on the same levelHello Statalist-Forum, I was wondering if you could help me with a problem: I have a continous outc…
simulation studyso i have to write a short programe for a simulation study, so far i have written program define my…
Multiline model name for long variable names using esttabHi users, I am using esttab to generate tables in Latex. I have long model name that I want to appe…
Set Seed Random SampleI would like to obtain a nationally representative sample from a (non representative) survey data se…
Subscribe to:
Post Comments (Atom)
0 Response to Weighted Tabulation by Multiple Groups -- Export to XLS or DTA
Post a Comment