Proc Report rounding over 1 million

LuAnnS — Tue, 03 Dec 2019 15:13:30 GMT

I'm having trouble with proc report. I run a proc sort, set my options then run a proc report on a dataset that has all numbers previously rounded in an earlier step (= round(field_name * factor,.01);). I can see in the dataset what the pennies are. If I export the dataset to excel, I have the same pennies. When i run proc report though, all calculated amounts over one million are rounding the pennies to the nearest tenth. It's not doing this to numbers under one million. I'm writing my code in SAS EG 7.15 HF7 (7.100.5.6177) (32-bit). Is this an issue anyone else has found? Am I using the wrong options, tags or attributes? it's a very complex program so i'm trying to pull out part of the code that might be helpful. Thanks in advance for any thoughts/ideas you might have

OPTIONS MISSING=' ' nobyline bottommargin=.1IN topmargin=.1IN leftmargin=.1IN rightmargin=.1IN;
Ods tagsets.excelxp options (sheet_name='National Detail' ORIENTATION="LANDSCAPE" embedded_titles = "yes"
frozen_headers = '4' row_repeat = '1-4' skip_space='1,1,0,1,1' Center_Horizontal= 'yes'
autofit_height='yes');

define field_name /analysis 'field*title' style=[WIDTH=.7IN tagattr="format:$#,##0;[Red]$#,##0$" ]
style(header)={BACKGROUND=VERY LIGHT moderate green};

Re: Proc Report rounding over 1 million

LuAnnS — Tue, 03 Dec 2019 16:10:01 GMT

I tried adding a format to the define statement but it didn't change the excel output

define DENFI_Prem_Curr /analysis 'FI*Den' Format=DOLLAR9.2 style=[WIDTH=.9IN tagattr="format:$#,##0.00;[Red]$#,##0.00$" ]
style(header)={BACKGROUND=VERY LIGHT moderate green};

Re: Proc Report rounding over 1 million

Tom — Tue, 03 Dec 2019 16:25:21 GMT

A format of DOLLAR9.2 will not have room for numbers over 1 million.

That would require a format width of 13 characters.

59    data _null_;
60      input ;
61      list;
62    cards;

RULE:       ----+----1----+----2----+----3----+----4
63          $1,000,000.23

topic Re: Proc Report rounding over 1 million in SAS Programming

Proc Report rounding over 1 million

Re: Proc Report rounding over 1 million

Re: Proc Report rounding over 1 million