ods and proc tabulate report

ameey — Thu, 07 May 2015 14:13:16 GMT

Hi Cynthia/All

Please guide me how can I keep the value of total column for a particular indicator as a blank cell in proc tabulate. As given below i have enclosed a the requirement sheet where we have to put blank cell in a total column for a particular indicators only and rest should come with the sum of all months. I have attached a small Data set and sas code. Anyone can reply me with correct solution.

Re: ods and proc tabulate report

Cynthia_sas — Mon, 14 Sep 2015 15:10:53 GMT

Hi:

With TABULATE, you cannot suppress a cell, such as you describe, but with PROC REPORT, you can suppress or alter the data in a cell. Please see this example:

Produced by this program:

ods msoffice2k file='c:\temp\all_india_mso.html' style=styles.normal;

%let finyear=2015;
%let update=9/13/2015;
TITLE1   FONT="Trebuchet MS" height=11pt color=black " Data ItemWise Report for - All India ";
TITLE2   FONT="Trebuchet MS" height=11pt color=black " Provisional Figures for - &Finyear ";
TITLE3   FONT="Trebuchet MS" height=11pt color=black " Status As On: &Update ";

** sort by monthid_n then use order=data in PROC REPORT;
** to make month values sort in desired order;
proc sort data=work.data2;
by statename_v misconsheadercode_v misconsheadername_v monthid_n;
run;

options missing=' ';
proc report data=WORK.DATA2 nowd missing;
column STATENAME_V MISCONSHEADERCODE_V MISCONSHEADERNAME_V DETAIL value_n,MONTHNAME_V value_n=vtot;
define STATENAME_V / 'State' group
         style(header)=Header{color=vigb FONT_FACE='Trebuchet MS'}
         style(column)=Header{color=vigb FONT_FACE='Trebuchet MS'};
define misconsheadercode_v / ' 'group
         style(column)=Header{color=vigb FONT_FACE='Trebuchet MS'};
define misconsheadername_v / ' 'group
         style(column)=Header{color=vigb FONT_FACE='Trebuchet MS'};
define detail / group ' ' style(column)=Header{color=vigb FONT_FACE='Trebuchet MS'};
define MONTHNAME_V / across ' ' order=data
         style(header)=Header{color=vigb FONT_FACE='Trebuchet MS'};
define value_n / sum ' '
         style(header)=Header{color=vigb FONT_FACE='Trebuchet MS'};
define vtot / 'Total'
         style(header)=Header{color=vigb FONT_FACE='Trebuchet MS'};
compute vtot;
    if misconsheadercode_v in ( '1.1.1', '1.3', '1.6.1') then vtot = .;
endcomp;
run;

ods _all_ close;

cynthia

topic Re: ods and proc tabulate report in ODS and Base Reporting

ods and proc tabulate report

Re: ods and proc tabulate report