data WORK.VIOLATION; infile datalines dsd truncover; input code:BEST. year:BEST. Violatio0T1pe:$182. Violatio0T1peID:$41. SumPe0alt1:BEST. IsViolated:BEST. Pu0ishme0tT1pe:$54. Pu0ishme0tT1peID:$23. penalty_amount:BEST.; format code BEST. year BEST. SumPe0alt1 BEST. IsViolated BEST. penalty_amount BEST.; label code="code" year="year" Violatio0T1pe="Violatio0T1pe" Violatio0T1peID="Violatio0T1peID" SumPe0alt1="SumPe0alt1" IsViolated="IsViolated" Pu0ishme0tT1pe="Pu0ishme0tT1pe" Pu0ishme0tT1peID="Pu0ishme0tT1peID" penalty_amount="penalty_amount"; datalines; 3 2001 deferred discolsure P2504 . 1 Condmn P2603 . 3 2002 other P2599 . 1 criticism P2601 . 4 2002 deferred discolsure P2504 . 1 Condmn P2603 . 4 2010 False record(Misleading statements), P2503,P2599 . 1 criticism P2601 . 4 2010 Major omissions,False disclosure(), P2505,P2506,P2599 . 0 . 4 2013 False record(Misleading statements),Improper handling of general accounting,other P2503,P2515,P2599 . 1 other P2699 . 4 2018 deferred discolsure P2504 580000 1 warning,forfeit P2602,P2604 400000 5 2018 deferred discolsure P2504 . 1 other P2699 . 6 2010 False record(Misleading statements),Deferred disclosure,Major omissions,other P2503,P2504,P2505,P2599 . 1 other P2699 . 7 2010 Illegal trading of stocks P2512 . 0 . 7 2008 deferred discolsure P2504 . 0 . 7 2012 False records (misleadi0g stateme0ts) P2503 . 0 . 7 2013 Major omissions,other P2505,P2599 . 1 criticism P2601 . 7 2014 False record(Misleading statements),Major omissions, P2503,P2505,P2599 800000 1 warning,forfeit P2602,P2604 400000 7 2014 False record(Misleading statements),Deferred disclosure, P2503,P2504,P2599 . 1 Condmn P2603 . 7 2014 False record(Misleading statements),Major omissions,other P2503,P2505,P2599 . 1 other P2699 . 7 2015 Deferred disclosure, P2504,P2599 . 1 criticism P2601 . 7 2015 Major omissions,other P2505,P2599 600000 0 . 7 2015 Deferred disclosure,employ firm assets,other P2504,P2510,P2599 . 1 other P2699 . 7 2016 Deferred disclosure,Major omissions, P2504,P2505,P2599 . 0 . 7 2015 False disclosure(),Major omissions, P2506,P2505,P2599 980000 1 warning,forfeit P2602,P2604 600000 7 2016 deferred discolsure P2504 800000 1 warning,forfeit P2602,P2604 300000 9 2016 False record(Misleading statements),Deferred disclosure,Major omissions, P2503,P2504,P2505,P2599 . 1 Condmn P2603 . 9 2002 deferred discolsure P2504 . 1 criticism P2601 . 9 2003 Deferred disclosure, P2504,P2599 . 1 criticism P2601 . 9 2011 False records (misleading statements) P2503 . 1 criticism P2601 . 10 2018 False disclosure(),Improper handling of general accounting P2506,P2515 . 1 other P2699 . 10 2009 False record(Misleading statements),Deferred disclosure,Major omissions, irregularities and guarantees,Improper handling of general accounting,other P2503,P2504,P2505,P2514,P2515,P2599 . 1 other P2699 . 10 2010 False record(Misleading statements),Major omissions,employ firm assets P2503,P2505,P2510 . 1 criticism P2601 . 10 2011 Deferred disclosure,False disclosure(),employ firm assets,Improper handling of general accounting,other P2504,P2506,P2510,P2515,P2599 . 1 other P2699 . ;;;; Hello @Kurt_Bremser I hope it is done this time
... View more