Format and informat of the drill through table not applied

[milts]

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!

[Patrick]

Which SAS version are you using?

[milts]

Hi Patrick,

It's 9.1.3

[Patrick]

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

[milts]

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!

[Patrick]

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.