Dear experts,
I have a table like this:
Year Violation Year
2010 2005,2006,2007,2008,2009,2010
Both "Year"and "Violation Year" are string. How can I extract the multiple years in "Violation Year" seperately to make the below happen?
Year Violation Year
2010 2005
2010 2006
2010 2007
2010 2008
2010 2009
2010 2010
Thank you so much!
Related Posts with Extract different parts from one variable
Data display in browser converting from 24 hr clock to 12 hour clockIn the data browser Stata is displaying 12jun2018 16:38:53 as 6/12/2018 4:33 as if it were labeling …
KHB command for mediation analysis Hello. I am using the user-written command "KHB" (Karlson/Holm/Breen) to run a mediation analysis (…
History Pane in Command window - how to set the max capacity of thishello stata people, complete newcomer here, I have been using the command history pane of the comman…
Time and region fixed effects (When is it appropriate to use c. and i. for the time trends?)I did come to realize that when controlling for time effects and region effects in a regular regress…
Why is this regression in Stata not progressing nor returning an error code?Note: Originally posted on Stack Overflow, but crossposted here following advice. I am running a m…
Subscribe to:
Post Comments (Atom)
0 Response to Extract different parts from one variable
Post a Comment