How would we go about this same issue if we had multiple variables of interest? (Hence our data would already be wide and long) Thank you for any advice!
Hmmm, you may be able to use multiple stubs? I can try this later to see. Otherwise I may just extract into separate data sets. I’m sure there is a more efficient way, but when in doubt I just divide and conquer!
hi Petra, were you able to figure this out? I am in a similar situation whith a lot of variables and your experience might save me a lot of time. Thanks.
It really shouldn't be any different. Just treat each column (wide form) as a "time period." It doesn't matter if its annual or quarterly or daily even.
@@toddr.yarbroughph.d.478 Question. I have limited knowledge of computers. I can do quite a bit in Excel. I can do QuickBooks. But I really don't have much experience beyond that. How long would it take me to independently become proficient in Stata?
try: reshape wide var, i(panelvar) j(timevar) OR you can also just use a collapse command to get average for years. Be sure to save data set first though, as collapse changes it. collapse (mean) varname, by(timevar)
It is really of great help to my graduation thesis, finally getting to a start. Thanks a lot!
Can I just say I have been stuck on this and you just helped . honestly thank you.
I swear this video helped me. Thank you. Nice and straightforward
you are an absolute legend, thank you so much for this!
Thank you very much for this insightful and extremely helpful video! Doing God's work truly!
Sir, amazing ...gratitude
In my dataset, there's no data from 1960 to 1988 in the same world bank co2 dataset. How's that possible?
This video helped me so much! Thank you.
Good job sir. Thanks 👍
Thanks for this. What if the date should be monthly? For instance, I am looking for a way to convert a j=4 to 29Jan1986.
Exactly what I needed to do! Thanks a lot!
How would we go about this same issue if we had multiple variables of interest? (Hence our data would already be wide and long) Thank you for any advice!
Hmmm, you may be able to use multiple stubs? I can try this later to see. Otherwise I may just extract into separate data sets. I’m sure there is a more efficient way, but when in doubt I just divide and conquer!
hi Petra, were you able to figure this out? I am in a similar situation whith a lot of variables and your experience might save me a lot of time. Thanks.
@@lubin509 Hi were you able to find a solution?
Thank Todd, nice vid! How would I be able deal with quarters instead years? Thanks in advance...
It really shouldn't be any different. Just treat each column (wide form) as a "time period." It doesn't matter if its annual or quarterly or daily even.
@@toddr.yarbroughph.d.478 Question. I have limited knowledge of computers. I can do quite a bit in Excel. I can do QuickBooks. But I really don't have much experience beyond that. How long would it take me to independently become proficient in Stata?
how do you do the opposite? because I want to calculate averages for each year but my data looks like what you have at the end result.
try:
reshape wide var, i(panelvar) j(timevar)
OR you can also just use a collapse command to get average for years. Be sure to save data set first though, as collapse changes it.
collapse (mean) varname, by(timevar)
could you share the next part of this video ? it helps a lot .. thanks a lot
What particularly did you have in mind?
Thank you so much. Clutch af.
Is there a way we can do this using python or excel power query?
See link. In my few forays into Python I've found this very useful: www.danielmsullivan.com/pages/tutorial_stata_to_python.html
Thank you
Thank you!
Great! Thanks a lot!
I need bank loans data guide me plz
Where/when?