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 ... View more

    Hi SAS Experts, I noticed that the the proc report sums the percentages on the breake. Which does not make sense in my case. How can I "re"-calculate the percentages for the break/totals e.g. BIGORG_CODE?   proc report data=DATASELECT_BIGORG; COLUMN BIGORG_CODE BIGORG_MATRIX MATRIX_GROUP_TEXT ('Source'         ('COUNTRYX'(                                  ('' COUNT_COUNTRYX)                                          ('' RHG_COUNTRYX) )                      ('' RHG_COUNTRYX_PERCENT)                      ('' RHGBEANSTAN_COUNTRYX)                      ('' RHGBEANSTAN_COUNTRYX_PERCENT))  ); DEFINE BIGORG_CODE / GROUP 'Code'; DEFINE MATRIX_GROUP_TEXT / 'Main Group'; DEFINE BIGORG_MATRIX / 'Matrix'; DEFINE COUNT_COUNTRYX /  'n'; DEFINE RHG_COUNTRYX /  '>RHG'; DEFINE RHG_COUNTRYX_PERCENT /  '%' format=nlnum20.1; BREAK AFTER BIGORG_CODE / summarize style=[backgroundcolor=#C8CCA8 fontsize=1 fontfamily=arial];   /*coloring*/ COMPUTE RHG_COUNTRYX_PERCENT; IF RHG_COUNTRYX_PERCENT.SUM > 1 AND RHG_COUNTRYX_PERCENT.SUM ne . THEN call define(_col_,"style","style={background=#2F75B5 foreground=white fontsize=1}"); ENDCOMP; run; ... View more