how to rename while using proc print in result tab

ysreenumba — Thu, 06 Sep 2018 01:13:15 GMT

Hi All,

how to rename deptno as "Total Sal of 10" in result tab while using proc print.

data ndk;
input id name$ sal job $ deptno;
cards;
1 A 100 sales 10
3 C 300 hr 20
2 B 100 finance 30
4 D 400 sales 10
3 C 300 hr 20
;
run;
proc sort data=ndk out=nk;
by deptno;
run;
proc print data=nk;
by deptno;
sum sal;
run;

output

Re: how to rename while using proc print in result tab

Reeza — Thu, 06 Sep 2018 02:30:34 GMT

Use the SUMLABEL option with BY as illustrated here:

proc sort data=sashelp.class out=class;                                    
   by sex;                                                                 
run;  
                                                             
proc format;                                                               
   value $genderf                                                          
      'F'='Female'                                                         
      'M'='Male';                                                          
run;                                              
                                                                           
proc print data=class noobs                                                
     sumlabel='#byval(sex) Total' grandtotal_label='Grand Total';   
   by sex;                                                                 
   var name age height weight;                                             
   sum height weight;                                                                                                                                 
   format sex $genderf.;                                                   
run;

Source: http://support.sas.com/kb/51/927.html

@ysreenumba wrote:

Hi All,

how to rename deptno as "Total Sal of 10" in result tab while using proc print.

data ndk;
input id name$ sal job $ deptno;
cards;
1 A 100 sales 10
3 C 300 hr 20
2 B 100 finance 30
4 D 400 sales 10
3 C 300 hr 20
;
run;
proc sort data=ndk out=nk;
by deptno;
run;
proc print data=nk;
by deptno;
sum sal;
run;

output

topic how to rename while using proc print in result tab in SAS Programming

how to rename while using proc print in result tab

Re: how to rename while using proc print in result tab