data data ;
input month $1-10 year $10-14 level $15-24 count 28-34 precent 35-42;
datalines;
March 2018 L2011_12 24 0.003
March 2018 L2011_3 25 0.003
March 2018 L2014_12 187 0.021
March 2018 L2014_3 8455 0.971
March 2018 L2017 20 0.002
March 2018 NYSPCMH 0 0
June 2018 L2011_12 2 0
June 2018 L2011_3 5 0.001
June 2018 L2014_12 136 0.015
June 2018 L2014_3 8907 0.98
June 2018 L2017 42 0.005
June 2018 NYSPCMH 0 0
September 2018 L2011_12 14 0.002
September 2018 L2011_3 7 0.001
September 2018 L2014_12 135 0.015
September 2018 L2014_3 8597 0.966
September 2018 L2017 73 0.008
September 2018 NYSPCMH 74 0.008
December 2018 L2011_12 0 0
December 2018 L2011_3 0 0
December 2018 L2014_12 134 0.015
December 2018 L2014_3 7930 0.906
December 2018 L2017 73 0.008
December 2018 NYSPCMH 613 0.07
March 2019 L2011_12 0 0
March 2019 L2011_3 0 0
March 2019 L2014_12 139 0.015
March 2019 L2014_3 7446 0.817
March 2019 L2017 77 0.008
March 2019 NYSPCMH 1454 0.159
;
data data1(drop = month year);
set data ;
date = input (catx(' ','1',month,year),anydtdte18.);
format date monyy7.;
format precent percent10.;
run; thank you for helping!
... View more