topic Re: Removing decimals places in SAS in SAS Programming

Removing decimals places in SAS

zdassu — Thu, 04 Jul 2019 10:11:21 GMT

Hi I have a table with decimal places, The field is text and I want to remove the decimal places which have no values. See examples below

Current Table

Field_1

22.5

1.000

40.000

1.25

I would like the table to look as per below, your help in this matter is much appreciated

Field_1

22.5

1.25

Re: Removing decimals places in SAS

PeterClemmensen — Thu, 04 Jul 2019 10:19:46 GMT

data have;
input Field_1 $;
datalines;
22.5
1.000
40.000
1.25
;

data want;
    set have;
    Field_2=put(input(Field_1, best8.), best8. -l);
run;

Re: Removing decimals places in SAS

RM6 — Thu, 04 Jul 2019 10:20:37 GMT

use strip(put(input(field_1,8.2),best.))

Re: Removing decimals places in SAS

Kurt_Bremser — Thu, 04 Jul 2019 10:37:14 GMT

@RM6 wrote:
use strip(put(input(field_1,8.2),best.))

Your use of the 8.2 informat is not needed and actually dangerous:

data have;
input field1 :$10.;
datalines;
22.5
1.000
40.000
1.25
4000
;

data want;
set have;
field2 = strip(put(input(field1,8.2),best.));
run;

Take a close look at the last observation.

8. (or simply best.) is sufficient.

Re: Removing decimals places in SAS

Ksharp — Thu, 04 Jul 2019 11:17:30 GMT

data have;
input Field_1 $;
want=prxchange('s/\.0+\s*$//',1,field_1);
cards;
22.5
1.000
40.000
1.25
;

Re: Removing decimals places in SAS

Kurt_Bremser — Thu, 04 Jul 2019 11:20:34 GMT

Treating it as a character operation only:

data want;
set have;
field2 = scan(field1,1,'.');
run;

Re: Removing decimals places in SAS

koyelghosh — Thu, 04 Jul 2019 12:21:52 GMT

@zdassu You are trying to mix two formats: 1st and 4th row have decimal places while 2nd and 3rd don't have a decimal. For the entire column/variable you will have to settle down to one choice: with or without decimal. I am not sure if you can choose differently for different rows. So either you decide between 8 and 8.2 (without and with 2 decimals respectively) or let SAS decide with best. option.

Either ways, if I am not wrong, all rows have to conform to one standard/format for that particular column. If I am wrong please correct me.

Re: Removing decimals places in SAS

bollurajkumar — Thu, 04 Jul 2019 12:53:00 GMT

Treat as numaric and use round function as shown below, if it is character then use input function
data have;
input Field_1 ;
Field2=round(Field_1, .01);
datalines;
22.5
1.000
40.000
1.25
;
Run;

Re: Removing decimals places in SAS

ScottBass — Fri, 05 Jul 2019 00:11:01 GMT

I'll bite...why are you storing numeric data as character text? I suspect that's how your data is now, or how it is provided to you. But IMO if you stored or converted your text data to numeric, then used formats for display, reporting, etc., life would be easier.