Hi Forum,
I am struggling with something very silly but would be very helpful if someone could help me out.
I have an id variable which identifies the product and the size (e.g Coca Cola 600 ml)
Since my analysis is to evaluate a policy impact, I want to make sure that for the same product I have observations for both years.
However, there are some products that I have N observations for one year and 0 for the other, which could bias my research.
I am trying to drop those products who do not have observations for both years so I can compare the changes between them
Any suggestions?
Many thanks!!
Best,
Lena
Related Posts with Matching observations across years for same id
Error Code: Repeaded Time Values Within PanelAll, Good morning. I am working with panel data from NBER's CPS that I've boiled down to 56,166 obs…
Quantitative independent variable with empty cellsHi, I am doing a logistic regression analysis with a binary outcome. I have an independent variable…
replacing word in variable labels that shows up in different positionsIn some of my variable labels I have a word I would like to replace by another word. However, the wo…
Help for analysing DatasetHi there, I have a dataset of 200'000 observations consisting of customer IDs for 14 years. I have …
Counting frequencies of one variable for each value of another variableHello Statalist, I am working with a labor force survey in which each observation represents an ind…
Subscribe to:
Post Comments (Atom)
0 Response to Matching observations across years for same id
Post a Comment