topic Re: SAS Enterprise Guide 5 HTML Output (Custom Formatting)(ActiveX Control) in Graphics Programming

SAS Enterprise Guide 5 HTML Output (Custom Formatting)(ActiveX Control)

crench — Sat, 18 Mar 2017 14:09:12 GMT

Hello,

I have recently completed a custom report in SAS Enterprise Guide 5 that contains several GCHART & GBARLINE charts. The values for the axes of the charts have been formatted to the specifications of the audience for the report: e.g Date(MM/YY),Currency($#,###).This report has been exported to HTML format so that users without SAS installed can access the report via the SAS/GRAPH ActiveX Control.

When the report is accessed by users without SAS via the SAS/GRAPH ActiveX Control, they are able to see the chart. However, the formatting that is present in the charts in SAS is not updated in the charts. The values revert to a basic format: e.g Date(#####)<-SAS Date Value, Currency(####).

How do I export my reports to HTML in a way that preserves the formatting that I have created in SAS, so that Non-SAS users with the SAS/GRAPH ActiveX Control can see the charts with the Formatting:Date(MM/YY),Currency($#,###) that has been created in SAS?

Re: SAS Enterprise Guide 5 HTML Output (Custom Formatting)(ActiveX Control)

Reeza — Sat, 18 Mar 2017 16:23:02 GMT

SAS 9.4 TS1M4?

Can you post some basic code so we can replicate the issue and/or attach a sample HTML file.

Re: SAS Enterprise Guide 5 HTML Output (Custom Formatting)(ActiveX Control)

crench — Sat, 18 Mar 2017 22:03:47 GMT

Hello, Reeza

Thanks for your reply.My SAS Enterprise Guide version is 5.1 (5.100.0.12019). My Base SAS version is base sas 9.3_M2.

A code sample is below:

PROC GBARLINE DATA=WORK.SORTTempTableSorted

;

BAR Month

SUMVAR="COUNT DISTINCT_of_Acct #2"n

SUBGROUP="Disposal Channel"n

FRAME DISCRETE

TYPE=MEAN

NOZERO

COUTLINE=SAME

RAXIS=AXIS1

MAXIS=AXIS2

LEGEND=LEGEND2

;

PLOT / SUMVAR=AVG_of_RESIDUALALL

TYPE=MEAN

AXIS=AXIS3

LEGEND=LEGEND1

;

PLOT / SUMVAR=AVG_of_DLRMARK

TYPE=MEAN

AXIS=AXIS3

;

PLOT / SUMVAR=AVG_of_AUCT

TYPE=MEAN

AXIS=AXIS3

;

FORMAT Month MMYYS5.

"COUNT DISTINCT_of_Acct #2"n COMMA9.;

LABEL Month="Disposal Month"

"COUNT DISTINCT_of_Acct #2"n="Volume of Accounts"

AVG_of_RESIDUALALL="Average Residual"

AVG_of_DLRMARK="Average Dealer Market Gross Proceeds"

AVG_of_AUCT="Average Auction Gross Proceeds";

FORMAT Month MMYYS5.

"COUNT DISTINCT_of_Acct #2"n COMMA9.;

LABEL Month="Disposal Month"

"COUNT DISTINCT_of_Acct #2"n="Volume of Accounts"

AVG_of_RESIDUALALL="Average Residual"

AVG_of_DLRMARK="Average Dealer Market Gross Proceeds"

AVG_of_AUCT="Average Auction Gross Proceeds";

/* -------------------------------------------------------------------

End of task code.

Re: SAS Enterprise Guide 5 HTML Output (Custom Formatting)(ActiveX Control)

Reeza — Sat, 18 Mar 2017 21:26:00 GMT

You need to include data and/or reference a SASHELP so that we can actually run the code.

Unfortunately I don't have SAS/GRAPH at home so I can't run any of this, someone else will have to help. I'll move the question to the ODS Graph forum where it will probably get a correct answer soon :).

Re: SAS Enterprise Guide 5 HTML Output (Custom Formatting)(ActiveX Control)

crench — Sat, 18 Mar 2017 22:05:26 GMT

Hello,

My previous post has been updated to include both a code sample and a data sample. Thank you for your reply.