topic Re: Round Function without losing trailing zeros in SAS Programming

Round Function without losing trailing zeros

kmardinian — Wed, 05 Jun 2019 17:33:00 GMT

Hi, I am trying to round an average to one decimal place without losing the trailing zero if it rounds to a whole number.

For example 8.255 --> 8.3

10.01--->10.0 (instead of 10, which my program is currently outputting)

data x;

set y;

avg=round(average,0.1);

run;

Thank you, any help is much appreciated

Re: Round Function without losing trailing zeros

Astounding — Wed, 05 Jun 2019 17:41:10 GMT

Numeric variables don't contain digits. They only contain values. If you want to print with one position after the decimal point, apply a format. For example, if all your numbers are less than 1000, you could add:

format x 5.1;

Once you do that, you can remove the ROUND function

Re: Round Function without losing trailing zeros

kmardinian — Wed, 05 Jun 2019 17:58:57 GMT

Thank you, that worked perfectly!

Re: Round Function without losing trailing zeros

kmardinian — Wed, 05 Jun 2019 18:01:19 GMT

Is there a way to ensure that this will correctly output to once decimal place in an excel file?

Re: Round Function without losing trailing zeros

Astounding — Wed, 05 Jun 2019 18:05:38 GMT

I can't say. I never exported data to Excel.

Re: Round Function without losing trailing zeros

ballardw — Wed, 05 Jun 2019 20:03:57 GMT

@kmardinian wrote:

Is there a way to ensure that this will correctly output to once decimal place in an excel file?

How are you intending to send data to Excel? Some won't, Proc Export for example, and others basically just set the EXCEL display rule using TAGATTR in one of the report procedures.

Re: Round Function without losing trailing zeros

kmardinian — Wed, 05 Jun 2019 20:16:50 GMT

I was going to use a proc report ODS statement

ODS _ALL_ CLOSE;
ods excel file = "&outpath.&file..xlsx"
options ( SHEET_NAME="Report"
AUTOFILTER = "all"
EMBEDDED_TITLES ="yes"
ORIENTATION ="landscape"
frozen_headers='3'
absolute_column_width='8, 10, 16, 12'
) ;

proc report data=xx