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!