First create Stored process this code after excel output not show data class;
set sashelp.class;
Age_c=put(age, 3.);
run;
PROC SQL;
CREATE TABLE DATA1 AS
SELECT
t1.Name,
put(input(t1.Age_c,best4.),z4.) as HEAD1 format=$4.,
input(t1.Age_c,best4.) as HEAD2 format=z4.,
t1.age as HEAD3 format=z4.
from class t1;
quit;
ods excel file="c:\temp\data.xlsx";
proc report data=data1;
run;
ods excel close;
... View more
