data TEST;
input month: date9.. YES NO PCT_YES :commax. PCT_NO :commax.
format motnth monyy5.;
datalines;
1JAN2021 163 22 70,34 23,55
3JAN2021 198 22 45,34 34,34
1FEB2021 155 18 34.23 12,3
12FEB2021 116 19 89,3 23,3
1MAR2021 163 22 70,34 23,55
3APRIL2021 198 22 45,34 34,34
1MAY2021 155 18 34.23 12,3
12JUN2021 116 19 89,3 23,3
;
etc..
/*proc report*/
proc transpose data=test out=long;
by month notsorted;
var yes no Pct_yes Pct_no;
run;
data long1;
set long;
length val $6;
if indexc(_name_,"_")
then do;
_name_ = scan(_name_,2,"_");
val = "Pct.";
end;
else val = "number";
run;
proc report data=long1;
column _name_ month,(val, col1);
define _name_ / "" group order=data;
define month / "" across order=internal;
define val / "" across order=internal;
define col1 / "" sum ;
run;
... View more