Hi, Please find my proc tabulate code.I want to add another column that will* sum=Employee Total+Total Third Party* PROC TABULATE DATA=REPORT.SEA_OPCO FORMAT=10. ; VAR total_employee2 total_employee3 x; CLASS employee_person_type3 / DESCENDING MISSING; CLASS Operation employee_person_type2/ MISSING s=[background=yellow]; class dummy / MISSING s=[background=black]; TABLE /* ROW Statement */ Operation = '' all = ' Region Total', /* COLUMN Statement */ Employee_Person_Type3='' *(total_employee3=' ' * Sum={LABEL=" "} ) all = ' Employee Total' *(total_employee3=' ' * Sum={LABEL=" "} ) dummy=' '*x=''*sum=''*{style={background=black }} Employee_Person_Type2='' *(total_employee2=' ' * Sum={LABEL=" "} ) all = ' Total Third Party' *(total_employee2=' ' * Sum={LABEL=" "} ) / misstext='0' box=[label="OpCo" style=[background=yellow]]; keyword all /s=[background=yellow]; RUN; ##- Please type your reply above this line. Simple formatting, no attachments. -##
... View more