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