Dear All, I have this dataset,
and wish to have the following results:
Any suggestions? Thanks.
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str12 Symbol str93 ViolationYear "000002" "2015;2016" "000002" "2016" "000004" "2008;2009" "000004" "2007;2008;2009;2010" "000004" "2010;2012;N/A" "000004" "2014;2016" "000004" "2014;2016" end
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str12 Symbol ViolationYear "000002" 2015 "000002" 2016 "000004" 2007 "000004" 2008 "000004" 2009 "000004" 2010 "000004" 2012 "000004" 2014 "000004" 2016 end
Comment