Hi,
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.
proc sql;
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;
quit;
The column shows:
1000,000
0,010
1,000
-
null
>SGF
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
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?
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.