I have a dataset on occupations by state over time that looks like this:
I want to randomly sort the data first by occupation and then, within occupation, by state. I want this code to be reproducible.
What I have tried so far is:
This succeeds in shuffling the data the way I want it to, but it is not reproducible. Every time I run it, I get a different ordering of states within occupations.
How can I resolve this issue?
Any help would be much appreciated!
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str20 state str136 occ_title long state_occ float year "Alabama" "athletic trainers" 3 2003 "Alabama" "athletic trainers" 3 2004 "Alabama" "athletic trainers" 3 2005 "Alabama" "athletic trainers" 3 2006 "Alabama" "athletic trainers" 3 2007 "Alabama" "athletic trainers" 3 2008 "Alabama" "athletic trainers" 3 2009 "Alabama" "athletic trainers" 3 2010 "Alabama" "athletic trainers" 3 2011 "Alabama" "athletic trainers" 3 2012 "Alabama" "athletic trainers" 3 2013 "Alabama" "athletic trainers" 3 2014 "Alabama" "athletic trainers" 3 2015 "Alabama" "athletic trainers" 3 2016 "Alabama" "athletic trainers" 3 2017 "Alabama" "athletic trainers" 3 2018 "Alabama" "athletic trainers" 3 2019 "Alabama" "athletic trainers" 3 2020 "Alabama" "athletic trainers" 3 2021 "Alabama" "athletic trainers" 3 2022 "Alabama" "athletic trainers" 3 2023 "Alabama" "audiologists" 4 2003 "Alabama" "audiologists" 4 2004 "Alabama" "audiologists" 4 2005 "Alabama" "audiologists" 4 2006 "Alabama" "audiologists" 4 2007 "Alabama" "audiologists" 4 2008 "Alabama" "audiologists" 4 2009 "Alabama" "audiologists" 4 2010 "Alabama" "audiologists" 4 2011 "Alabama" "audiologists" 4 2012 "Alabama" "audiologists" 4 2013 "Alabama" "audiologists" 4 2014 "Alabama" "audiologists" 4 2015 "Alabama" "audiologists" 4 2016 "Alabama" "audiologists" 4 2017 "Alabama" "audiologists" 4 2018 "Alabama" "audiologists" 4 2019 "Alabama" "audiologists" 4 2020 "Alabama" "audiologists" 4 2021 "Alabama" "audiologists" 4 2022 "Alabama" "audiologists" 4 2023 "Alabama" "cardiovascular technologists and technicians" 6 2003 "Alabama" "cardiovascular technologists and technicians" 6 2004 "Alabama" "cardiovascular technologists and technicians" 6 2005 "Alabama" "cardiovascular technologists and technicians" 6 2006 "Alabama" "cardiovascular technologists and technicians" 6 2007 "Alabama" "cardiovascular technologists and technicians" 6 2008 "Alabama" "cardiovascular technologists and technicians" 6 2009 "Alabama" "cardiovascular technologists and technicians" 6 2010 "Alabama" "cardiovascular technologists and technicians" 6 2011 "Alabama" "cardiovascular technologists and technicians" 6 2012 "Alabama" "cardiovascular technologists and technicians" 6 2013 "Alabama" "cardiovascular technologists and technicians" 6 2014 "Alabama" "cardiovascular technologists and technicians" 6 2015 "Alabama" "cardiovascular technologists and technicians" 6 2016 "Alabama" "cardiovascular technologists and technicians" 6 2017 "Alabama" "cardiovascular technologists and technicians" 6 2018 "Alabama" "cardiovascular technologists and technicians" 6 2019 "Alabama" "cardiovascular technologists and technicians" 6 2020 "Alabama" "cardiovascular technologists and technicians" 6 2021 "Alabama" "cardiovascular technologists and technicians" 6 2022 "Alabama" "cardiovascular technologists and technicians" 6 2023 "Alabama" "chiropractors" 7 2003 "Alabama" "chiropractors" 7 2004 "Alabama" "chiropractors" 7 2005 "Alabama" "chiropractors" 7 2006 "Alabama" "chiropractors" 7 2007 "Alabama" "chiropractors" 7 2008 "Alabama" "chiropractors" 7 2009 "Alabama" "chiropractors" 7 2010 "Alabama" "chiropractors" 7 2011 "Alabama" "chiropractors" 7 2012 "Alabama" "chiropractors" 7 2013 "Alabama" "chiropractors" 7 2014 "Alabama" "chiropractors" 7 2015 "Alabama" "chiropractors" 7 2016 "Alabama" "chiropractors" 7 2017 "Alabama" "chiropractors" 7 2018 "Alabama" "chiropractors" 7 2019 "Alabama" "chiropractors" 7 2020 "Alabama" "chiropractors" 7 2021 "Alabama" "chiropractors" 7 2022 "Alabama" "chiropractors" 7 2023 "Alaska" "chiropractors" 91 2003 "Alaska" "chiropractors" 91 2004 "Alaska" "chiropractors" 91 2005 "Alaska" "chiropractors" 91 2006 "Alaska" "chiropractors" 91 2007 "Alaska" "chiropractors" 91 2008 "Alaska" "chiropractors" 91 2009 "Alaska" "chiropractors" 91 2010 "Alaska" "chiropractors" 91 2011 "Alaska" "chiropractors" 91 2012 "Alaska" "chiropractors" 91 2013 "Alaska" "chiropractors" 91 2014 "Alaska" "chiropractors" 91 2015 "Alaska" "chiropractors" 91 2016 "Alaska" "chiropractors" 91 2017 "Alaska" "chiropractors" 91 2018 "Alaska" "chiropractors" 91 2019 "Alaska" "chiropractors" 91 2020 "Alaska" "chiropractors" 91 2021 "Alaska" "chiropractors" 91 2022 "Alaska" "chiropractors" 91 2023 "Arkansas" "athletic trainers" 254 2003 "Arkansas" "athletic trainers" 254 2004 "Arkansas" "athletic trainers" 254 2005 "Arkansas" "athletic trainers" 254 2006 "Arkansas" "athletic trainers" 254 2007 "Arkansas" "athletic trainers" 254 2008 "Arkansas" "athletic trainers" 254 2009 "Arkansas" "athletic trainers" 254 2010 "Arkansas" "athletic trainers" 254 2011 "Arkansas" "athletic trainers" 254 2012 "Arkansas" "athletic trainers" 254 2013 "Arkansas" "athletic trainers" 254 2014 "Arkansas" "athletic trainers" 254 2015 "Arkansas" "athletic trainers" 254 2016 "Arkansas" "athletic trainers" 254 2017 "Arkansas" "athletic trainers" 254 2018 "Arkansas" "athletic trainers" 254 2019 "Arkansas" "athletic trainers" 254 2020 "Arkansas" "athletic trainers" 254 2021 "Arkansas" "athletic trainers" 254 2022 "Arkansas" "athletic trainers" 254 2023 "Arkansas" "audiologists" 255 2003 "Arkansas" "audiologists" 255 2004 "Arkansas" "audiologists" 255 2005 "Arkansas" "audiologists" 255 2006 "Arkansas" "audiologists" 255 2007 "Arkansas" "audiologists" 255 2008 "Arkansas" "audiologists" 255 2009 "Arkansas" "audiologists" 255 2010 "Arkansas" "audiologists" 255 2011 "Arkansas" "audiologists" 255 2012 "Arkansas" "audiologists" 255 2013 "Arkansas" "audiologists" 255 2014 "Arkansas" "audiologists" 255 2015 "Arkansas" "audiologists" 255 2016 "Arkansas" "audiologists" 255 2017 "Arkansas" "audiologists" 255 2018 "Arkansas" "audiologists" 255 2019 "Arkansas" "audiologists" 255 2020 "Arkansas" "audiologists" 255 2021 "Arkansas" "audiologists" 255 2022 "Arkansas" "audiologists" 255 2023 "Arkansas" "cardiovascular technologists and technicians" 257 2003 "Arkansas" "cardiovascular technologists and technicians" 257 2004 "Arkansas" "cardiovascular technologists and technicians" 257 2005 "Arkansas" "cardiovascular technologists and technicians" 257 2006 "Arkansas" "cardiovascular technologists and technicians" 257 2007 "Arkansas" "cardiovascular technologists and technicians" 257 2008 "Arkansas" "cardiovascular technologists and technicians" 257 2009 "Arkansas" "cardiovascular technologists and technicians" 257 2010 "Arkansas" "cardiovascular technologists and technicians" 257 2011 "Arkansas" "cardiovascular technologists and technicians" 257 2012 "Arkansas" "cardiovascular technologists and technicians" 257 2013 "Arkansas" "cardiovascular technologists and technicians" 257 2014 "Arkansas" "cardiovascular technologists and technicians" 257 2015 "Arkansas" "cardiovascular technologists and technicians" 257 2016 "Arkansas" "cardiovascular technologists and technicians" 257 2017 "Arkansas" "cardiovascular technologists and technicians" 257 2018 "Arkansas" "cardiovascular technologists and technicians" 257 2019 "Arkansas" "cardiovascular technologists and technicians" 257 2020 "Arkansas" "cardiovascular technologists and technicians" 257 2021 "Arkansas" "cardiovascular technologists and technicians" 257 2022 "Arkansas" "cardiovascular technologists and technicians" 257 2023 "Arkansas" "chiropractors" 258 2003 "Arkansas" "chiropractors" 258 2004 "Arkansas" "chiropractors" 258 2005 "Arkansas" "chiropractors" 258 2006 "Arkansas" "chiropractors" 258 2007 "Arkansas" "chiropractors" 258 2008 "Arkansas" "chiropractors" 258 2009 "Arkansas" "chiropractors" 258 2010 "Arkansas" "chiropractors" 258 2011 "Arkansas" "chiropractors" 258 2012 "Arkansas" "chiropractors" 258 2013 "Arkansas" "chiropractors" 258 2014 "Arkansas" "chiropractors" 258 2015 "Arkansas" "chiropractors" 258 2016 "Arkansas" "chiropractors" 258 2017 "Arkansas" "chiropractors" 258 2018 "Arkansas" "chiropractors" 258 2019 "Arkansas" "chiropractors" 258 2020 "Arkansas" "chiropractors" 258 2021 "Arkansas" "chiropractors" 258 2022 "Arkansas" "chiropractors" 258 2023 "California" "athletic trainers" 338 2003 "California" "athletic trainers" 338 2004 "California" "athletic trainers" 338 2005 "California" "athletic trainers" 338 2006 "California" "athletic trainers" 338 2007 "California" "athletic trainers" 338 2008 "California" "athletic trainers" 338 2009 "California" "athletic trainers" 338 2010 "California" "athletic trainers" 338 2011 "California" "athletic trainers" 338 2012 "California" "athletic trainers" 338 2013 "California" "athletic trainers" 338 2014 "California" "athletic trainers" 338 2015 "California" "athletic trainers" 338 2016 "California" "athletic trainers" 338 2017 "California" "athletic trainers" 338 2018 "California" "athletic trainers" 338 2019 "California" "athletic trainers" 338 2020 "California" "athletic trainers" 338 2021 "California" "athletic trainers" 338 2022 "California" "athletic trainers" 338 2023 "California" "audiologists" 339 2003 "California" "audiologists" 339 2004 "California" "audiologists" 339 2005 "California" "audiologists" 339 2006 "California" "audiologists" 339 2007 "California" "audiologists" 339 2008 "California" "audiologists" 339 2009 "California" "audiologists" 339 2010 "California" "audiologists" 339 2011 "California" "audiologists" 339 2012 "California" "audiologists" 339 2013 "California" "audiologists" 339 2014 "California" "audiologists" 339 2015 "California" "audiologists" 339 2016 "California" "audiologists" 339 2017 "California" "audiologists" 339 2018 "California" "audiologists" 339 2019 "California" "audiologists" 339 2020 "California" "audiologists" 339 2021 "California" "audiologists" 339 2022 "California" "audiologists" 339 2023 "California" "cardiovascular technologists and technicians" 341 2003 "California" "cardiovascular technologists and technicians" 341 2004 "California" "cardiovascular technologists and technicians" 341 2005 "California" "cardiovascular technologists and technicians" 341 2006 "California" "cardiovascular technologists and technicians" 341 2007 "California" "cardiovascular technologists and technicians" 341 2008 "California" "cardiovascular technologists and technicians" 341 2009 "California" "cardiovascular technologists and technicians" 341 2010 "California" "cardiovascular technologists and technicians" 341 2011 "California" "cardiovascular technologists and technicians" 341 2012 "California" "cardiovascular technologists and technicians" 341 2013 "California" "cardiovascular technologists and technicians" 341 2014 "California" "cardiovascular technologists and technicians" 341 2015 "California" "cardiovascular technologists and technicians" 341 2016 "California" "cardiovascular technologists and technicians" 341 2017 "California" "cardiovascular technologists and technicians" 341 2018 "California" "cardiovascular technologists and technicians" 341 2019 "California" "cardiovascular technologists and technicians" 341 2020 "California" "cardiovascular technologists and technicians" 341 2021 "California" "cardiovascular technologists and technicians" 341 2022 "California" "cardiovascular technologists and technicians" 341 2023 "California" "chiropractors" 342 2003 "California" "chiropractors" 342 2004 "California" "chiropractors" 342 2005 "California" "chiropractors" 342 2006 "California" "chiropractors" 342 2007 "California" "chiropractors" 342 2008 "California" "chiropractors" 342 2009 "California" "chiropractors" 342 2010 "California" "chiropractors" 342 2011 "California" "chiropractors" 342 2012 "California" "chiropractors" 342 2013 "California" "chiropractors" 342 2014 "California" "chiropractors" 342 2015 "California" "chiropractors" 342 2016 "California" "chiropractors" 342 2017 "California" "chiropractors" 342 2018 "California" "chiropractors" 342 2019 "California" "chiropractors" 342 2020 "California" "chiropractors" 342 2021 "California" "chiropractors" 342 2022 "California" "chiropractors" 342 2023 "Colorado" "audiologists" 428 2003 "Colorado" "audiologists" 428 2004 "Colorado" "audiologists" 428 2005 "Colorado" "audiologists" 428 2006 "Colorado" "audiologists" 428 2007 "Colorado" "audiologists" 428 2008 "Colorado" "audiologists" 428 2009 "Colorado" "audiologists" 428 2010 "Colorado" "audiologists" 428 2011 "Colorado" "audiologists" 428 2012 "Colorado" "audiologists" 428 2013 "Colorado" "audiologists" 428 2014 "Colorado" "audiologists" 428 2015 "Colorado" "audiologists" 428 2016 "Colorado" "audiologists" 428 2017 "Colorado" "audiologists" 428 2018 "Colorado" "audiologists" 428 2019 "Colorado" "audiologists" 428 2020 "Colorado" "audiologists" 428 2021 "Colorado" "audiologists" 428 2022 "Colorado" "audiologists" 428 2023 "Colorado" "cardiovascular technologists and technicians" 430 2003 "Colorado" "cardiovascular technologists and technicians" 430 2004 "Colorado" "cardiovascular technologists and technicians" 430 2005 "Colorado" "cardiovascular technologists and technicians" 430 2006 "Colorado" "cardiovascular technologists and technicians" 430 2007 "Colorado" "cardiovascular technologists and technicians" 430 2008 "Colorado" "cardiovascular technologists and technicians" 430 2009 "Colorado" "cardiovascular technologists and technicians" 430 2010 "Colorado" "cardiovascular technologists and technicians" 430 2011 "Colorado" "cardiovascular technologists and technicians" 430 2012 "Colorado" "cardiovascular technologists and technicians" 430 2013 "Colorado" "cardiovascular technologists and technicians" 430 2014 "Colorado" "cardiovascular technologists and technicians" 430 2015 "Colorado" "cardiovascular technologists and technicians" 430 2016 "Colorado" "cardiovascular technologists and technicians" 430 2017 "Colorado" "cardiovascular technologists and technicians" 430 2018 "Colorado" "cardiovascular technologists and technicians" 430 2019 "Colorado" "cardiovascular technologists and technicians" 430 2020 "Colorado" "cardiovascular technologists and technicians" 430 2021 "Colorado" "cardiovascular technologists and technicians" 430 2022 "Colorado" "cardiovascular technologists and technicians" 430 2023 end label values state_occ state_occ_code label def state_occ_code 3 "Alabama - athletic trainers", modify label def state_occ_code 4 "Alabama - audiologists", modify label def state_occ_code 6 "Alabama - cardiovascular technologists and technicians", modify label def state_occ_code 7 "Alabama - chiropractors", modify label def state_occ_code 91 "Alaska - chiropractors", modify label def state_occ_code 254 "Arkansas - athletic trainers", modify label def state_occ_code 255 "Arkansas - audiologists", modify label def state_occ_code 257 "Arkansas - cardiovascular technologists and technicians", modify label def state_occ_code 258 "Arkansas - chiropractors", modify label def state_occ_code 338 "California - athletic trainers", modify label def state_occ_code 339 "California - audiologists", modify label def state_occ_code 341 "California - cardiovascular technologists and technicians", modify label def state_occ_code 342 "California - chiropractors", modify label def state_occ_code 428 "Colorado - audiologists", modify label def state_occ_code 430 "Colorado - cardiovascular technologists and technicians", modify
I want to randomly sort the data first by occupation and then, within occupation, by state. I want this code to be reproducible.
What I have tried so far is:
Code:
set seed 123 gen random_var = rnormal() bysort occ_title year: replace random_var = random_var[1] sort random_var
How can I resolve this issue?
Any help would be much appreciated!
Comment