02-05-2016 02:32 AM
I wrote some proc sql to retrieve data from our Oracle DB.
Unfortunately the number formatting is a bit unfortunate on the Oracle side,
some Excel ETL process did not fix it now I have to do it on the reporting side.
connect to oracle as xxx (user=xxx password=xxxx' path=DATABASE);
create table mytab as
select * from connection to xxx
SELECT column from table
disconnect from xxx;
The column shows:
So its not all numbers really but if its a number I need to format it correctly i.e.
without decimal places if they are just trailing 0
02-05-2016 03:25 AM
In the SAS dataset/table MYTAB, what is the type of the variable COLUMN - character or numeric? Also what is the SAS format for the variable if any?
02-05-2016 11:21 AM
Your example data looks like it may have a fixed decimal format with a forced 3 decimal values, possibly something like 10.3 . The values are no different but if you do not want trailing zeroes shown then assign a BEST format like BEST10.
02-05-2016 11:52 AM