topic Re: Complex formatted out for html/ excel in Developers

Complex formatted out for html/ excel

SuniGoel — Wed, 05 Feb 2020 18:13:53 GMT

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.

Re: Complex formatted out for html/ excel

Vince_SAS — Fri, 07 Feb 2020 13:04:54 GMT

What are the steps for producing the output for Excel, and for opening it with Excel?

Vince DelGobbo

SAS R&D

Re: Complex formatted out for html/ excel

Sarojknayak — Mon, 10 Feb 2020 16:00:02 GMT

There two issues here.
1. Ods Tagset.excel is working in sas EG but not in WRS.
2. Dependency for cascading prompt works well in stored process but it fails when we use the same stored process in the WRS. As mentioned in the message above SAS environment is 9.2 version and SAS WRS is 4.3 version.

Re: Complex formatted out for html/ excel

Sarojknayak — Mon, 10 Feb 2020 16:01:50 GMT

The stored process was added to the WRS report. When report generated in wrs, report was exported to excel or html. Here excel and HTML export do not follow the format shown in the report.

Re: Complex formatted out for html/ excel

Vince_SAS — Mon, 10 Feb 2020 16:54:19 GMT

I think that SAS Web Report Studio only supports the SASREPORT* ODS destinations; you cannot use tagsets.ExcelXP.

In SAS 9.2 that would be SASREPORT11 or SASREPORT12.

Vince DelGobbo

SAS R&D