Hi Reeza, Sorry for ambiguity. Below approach worked out except PROC PRINT ignores my attempt to label the variable. I'd like to use proc print output as PDF. Should I make this Proc Print label issue separate post? There was another SOLVED post on this topic which suggested to use 'label' statement in the proc print. That didn't work out for me. proc sql;
create table freq as
select count(a1) as a1, count(a2) as a2, count(a3) as a3, count(a4) as a4,
count(a5) as a5,count(a6) as a6,count(a7) as a7, count(a8) as a8, count(a9) as a9,
count(a10) as a10,count(a11) as a11,count(a12) as a12, count(a13) as a13, count(a14) as a14,
count(a15) as a15,count(a16) as a16,count(a17) as a17
from op_only2;
quit;
proc transpose data=freq out=freq1; run;
proc sort data=freq1;
by descending col1;
run;
proc print data=freq1 NOOBS LABEL;
format _name_ $group.;
label _name_="DEFECT CATEGORIES";
run;
... View more
