Testing your own code is not a sin, it is a must:
69 data TEST;
70 input month $9 YES BEST12. NO BEST12. PCT_YES BEST12. PCT_NO BEST12. ;
71 datalines;
NOTE: Invalid data for YES in line 72 10-21.
NOTE: Invalid data for NO in line 72 22-33.
REGEL: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
72 february 163 22 70,34 23,55
month= YES=. NO=. PCT_YES=. PCT_NO=. _ERROR_=1 _N_=1
NOTE: Invalid data for YES in line 73 10-21.
NOTE: Invalid data for NO in line 73 22-33.
73 March 198 22 45,34 34,34
month= YES=. NO=. PCT_YES=. PCT_NO=. _ERROR_=1 _N_=2
NOTE: Invalid data for YES in line 74 10-21.
NOTE: Invalid data for NO in line 74 22-33.
74 May 155 18 34.23 12,3
month= YES=. NO=. PCT_YES=. PCT_NO=. _ERROR_=1 _N_=3
NOTE: Invalid data for YES in line 75 10-21.
NOTE: Invalid data for NO in line 75 22-33.
75 April 116 19 89,3 23,3
month= YES=. NO=. PCT_YES=. PCT_NO=. _ERROR_=1 _N_=4
NOTE: The data set WORK.TEST has 4 observations and 5 variables.
So I first had to straighten out your code:
data TEST;
input month :$9. YES NO PCT_YES :commax. PCT_NO :commax.;
datalines;
February 163 22 70,34 23,55
March 198 22 45,34 34,34
May 155 18 34.23 12,3
April 116 19 89,3 23,3
;
Please do this yourself in the future; it's not rocket science.
You need to first transpose this dataset, and manipulate the _NAME_ so that it can be used as ACROSS; you also need a second ACROSS variable, derived from _NAME_:
proc transpose data=test out=long;
by month notsorted;
var yes no pct_yes pct_no;
run;
data long2;
set long;
length val $6;
if indexc(_name_,"_")
then do;
_name_ = scan(_name_,2,"_");
val = "Pct.";
end;
else val = "Number";
run;
From that, run your PROC REPORT with nested ACROSS:
proc report data=long2;
column _name_ month,(val,col1);
define _name_ / "" group order=data;
define month / "" across order=data;
define val / "" across;
define col1 / "" sum;
run;
Result:
February March May April
Number Pct. Number Pct. Number Pct. Number Pct.
YES 163 70.34 198 45.34 155 3423 116 89.3
NO 22 23.55 22 34.34 18 12.3 19 23.3
