Hi Cynthia, End customer wants to see date and then the DOW below the date...maybe there is a different way to do it than how I am doing it in regards to the Across portion? Apologies about the code, it is a rather large program and I was just trying to isolate the portion that I thought would be needed. I've included the XP Tagsets portion for reference below. Yes, sending to Excel with XP. I've tried changing the out the compute block with various conditionals i.e. if not missing(_c11_) and not missing(_c12_) and _c11_ gt 0 and _c12_ gt 0 then _c13_ = (_c11_ / _c12_); as I thought perhaps missing or 0 values were causing the problem, but nothing seems to work. I would rather do it in a compute block, but if not I am going to just summarize the data outside of Proc Report (i.e. create a "Total" category) and do my calculations there instead without the need for the rbreak after / summarize. From every example I have seen online, I can't figure out why this is failing the way it is (i.e. only adding the computed variable to the first column sometimes....sometimes the first 3 columns). I can't see the original dataset I sent you right now in this window. I've been playing with trying to bring in less dates or more dates...so if the below computed columns don't add up to the dataset I sent originally, just know that isn't the reason it is failing. options missing=0;
ods noresults;
ods listing close;
ods tagsets.ExcelXP file="&outfile" style=sasweb;
ods tagsets.ExcelXP options(
embedded_titles='yes'
embedded_footnotes='yes'
frozen_headers='6'
embed_titles_once='no'
sheet_interval='bygroup'
sheet_label=' '
suppress_bylines='yes'
row_repeat='yes'
rowcolheadings='no'
Pages_fitwidth='1'
Font_Size='8pt'
sheet_name="Data.Widgets"
hidden_rows='5'
autofit_height='yes'
autofit_width='yes'
/* absolute_column_width='100,100,90,90,90,200,75,30,30*/
orientation='landscape'
/* autofilter='all'*/
);
/*Options nonumber nodate nocenter;*/
options nocenter;
title1;
title2;
title3;
ods listing close;
options missing=' ';
Proc report data=TEST split='^'
style(summary)=Header
style(column)=[font_size=8pt] nowindows;
column
WIDGET
DATE,DOW, (TOTAL DEFECTS PERCENT)
;
define WIDGET / group ' ^Widgets^ ' style={just=left cellwidth=130};
define DATE / across nozero ' ^Date^ ' style={just=center cellwidth=80}
style(column)={tagattr='TYPE:DateTime format:mm/dd/yy;@'} FORMAT=MMDDYY10.;
define DOW / across '' style={just=center cellwidth=130};
define TOTAL / sum 'TOTAL' F=COMMA7. STYLE={just=center cellwidth=40};
define DEFECTS / sum 'DEFECTS' F=COMMA7. STYLE={just=center cellwidth=40};
define PERCENT / computed 'PERCENT' f=PERCENT8.2 style={just=center cellwidth=30} ;
compute PERCENT;
_c4_ = _c2_ / _c3_ ;
_c7_ = _c5_ / _c6_ ;
_c10_ = _c8_ / _c9_ ;
_c13_ = _c11_ / _c12_ ;
endcomp;
rbreak after / summarize;
quit;
Run;
ods tagsets.ExcelXP close;
ods results;
/*Set titles back to default*/
title The SAS System;
title2;
title3;
... View more