I changed the format on an column in Management Console from none to 14. in an Oracle table in the metadata respository. When I look at the data in EG the format used is 12.. After importing the data into metadata respository I thought I could assign formats so that all users can see the data in the best format. Is there an additional step that I have to do?
At first you said the number was being displayed as 12. but now you are saying it is 14 characters of scientific notation. Which is it?
If you define the format to be 14. and the is only 10000, then that is what you will see, and depending on the output media (html, line printer, etc.) you may not see the leading spacing to make it 14 characters wide.
if you define the format to be 6. and the number is 123456789 SAS will print/display it as 1.23E8
Let me clarify. I have a numeric column named batch_load_timestamp in a oracle table that is always 14 digits long. In Management Console in the metadata respository the format was blank by default so I changed it to "14.". When I open the dataset from the server list in EG the column is displayed in scientific notation. The properites window show the format as "BEST12.0". EG appears to ignore the change I made in Management Console. I can user the query builder in EG and change the format to 14. and it displays correctly in the resulting dataset.
Ah, the mysteries of the MetaData server. It is constantly challenging my perception of reality as well. I think SAS over complicated itself into a royal mess with that thing. In my ignorant opinion, I believe some developers (technician minds) went wild without proper engineering design control.
Changing the format in metadata may not be enough. If EG is opening the data using the META engine (which sees things through the filter of metadata), then your format would be applied. However, if this is a preassigned library that EG is reading with the native library engine (ORACLE), then the database attributes of the "live" data are used -- the metadata attributes don't affect it.