topic Re: Format and informat of the drill through table not applied in SAS Enterprise Guide

Format and informat of the drill through table not applied

milts — Fri, 27 Nov 2009 07:42:25 GMT

Hi All,

I'm having problems with the drill through formats. The format set in the source table of the drill through does not apply when the drill through is opened in EG.
The format used is comma25.2 and this can be seen in the metadata, physical table and column properties of the drill through table in OLAP. Unfortunately, when I opened the drill through in EG and checked the column properties, BEST12. is the format specified. How can I modify the format? Howcome it doesn't reflect the format comma25.2?

Thanks!

Re: Format and informat of the drill through table not applied

Patrick — Sat, 28 Nov 2009 05:48:30 GMT

Which SAS version are you using?

Re: Format and informat of the drill through table not applied

milts — Sun, 29 Nov 2009 00:58:26 GMT

Hi Patrick,

It's 9.1.3

Re: Format and informat of the drill through table not applied

Patrick — Sun, 29 Nov 2009 06:19:01 GMT

Sounds to me like note 15453 which got fixed with Service Pack 3: http://support.sas.com/kb/15/453.html

http://ftp.sas.com/techsup/download/hotfix/e9_sp_fixes.html

Let us know if you're environment is on this fix level but you still have the issue.

HTH
Patrick

Re: Format and informat of the drill through table not applied

milts — Tue, 01 Dec 2009 05:27:20 GMT

Hi Patrick,

I tried installing the hotfix E9BD03 but the issue was not resolved. Do you know the particular hotfix for this? I could not find the specific hotfix that addresses the issue from the hotfix list found in the link you sent.

Thanks!

Re: Format and informat of the drill through table not applied

Patrick — Tue, 01 Dec 2009 11:09:02 GMT

According to the SAS note it's part of SP3 but I couldn't find the exact defect. Just make sure that your Server is at least on Service Pack 3 level.

If it is on SP3 level: Open a track with SAS Tech Support.