Hi All, I am using SAS 9.2 with WRS 4.3 version. We are using stored procedures to generate report. However, the major problems are 3-fold.
1) HTML numeric values are left aligned.
2) In excel, -ve numeric values are left aligned instead of right (while +ve values are correctly right aligned).
3) Lastly, cascaded dynamic user filter values in WRS are not coming.
The below is the code:
ODS HTML FILE='RTGS.HTML' style=sasweb;
proc report data= TEST_final nowd split='#' OUT=TEST_final1
style(report)=[bordercolor= black background=_undef_ rules=rows frame = void]
style(header)=[font_face="Arial" font_size=11pt borderrightwidth=0.2pt borderbottomwidth=0.2pt bordertopwidth=0.2pt
borderleftwidth=0.2pt ]
style(column)=[borderrightwidth=0.2pt borderbottomwidth=0.2pt bordertopwidth=0.2pt borderleftwidth=0.2pt]
style(lines)=[font_face="Arial" font_size=11pt];
Title;
column ('Debit' ('Name of the Work/Head of Account' DEBIT_DESC) AmountDR) ("" ONE)
('Credit'( ('Head of Account' Subdept)('Name of Work' DESCRIPTION) GLCR) AmountCR);
define SubDept/ group center order=data "" Width=20;
define Description / group "" Width=20;
define DEBIT_DESC / "" display Width=50;
define GLCR / order"GL Code" center Width=30;
define ONE / '' width=10 format=$1.;
define AmountDR/ style(column)={just=r} 'Amount Debit' analysis sum format=comma22.2;
define AmountCR/ style(column)={just=r} 'Amount Credit' analysis sum format=comma22.2;
BREAK AFTER Subdept / SUMMARIZE Suppress dol dul
style(summary)={font_weight=bold font_style=roman};
RBREAK AFTER / SUMMARIZE dol dul
style(summary)={font_weight=bold font_style=roman};
compute after Subdept;
AmountDR.sum = '';
GLCR='Sub Total';
endcomp;
compute after ;
Description = 'Total';
DEBIT_DESC='Total';
endcomp;
run;
ODS html close;
Any urgent help will be really very very appreciated.
