topic Re: Formatting a field, removing the decimals in SAS Programming

Formatting a field, removing the decimals

Anmolkhandelwal — Mon, 08 Apr 2019 15:50:14 GMT

I am trying to format a particular field in the below format: If the value is 60.00 it has to be displayed as 60. if the value is 14.32 it has to displayed as 1432 and if it is 0.00 then output should be 0 i.e. No decimal should be Displayed.

Below is the datasets and the option i have tried

data input_dataset;
input srno $ bill_amt $10.;
datalines;
1 60.00
2 0.00
3 14.32
;
run;

data test;
set input_dataset;
format mc062 $10.;
mc062 = put((bill_amt ),10.);
run;

Expected Result:

MC062:

1432

Re: Formatting a field, removing the decimals

ballardw — Mon, 08 Apr 2019 15:57:49 GMT

@Anmolkhandelwal wrote:

I am trying to format a particular field in the below format: If the value is 60.00 it has to be displayed as 60. if the value is 14.32 it has to displayed as 1432 and if it is 0.00 then output should be 0 i.e. No decimal should be Displayed.

Below is the datasets and the option i have tried

data input_dataset;
input srno $ bill_amt $10.;
datalines;
1 60.00
2 0.00
3 14.32
;
run;

data test;
set input_dataset;
format mc062 $10.;
mc062 = put((bill_amt ),10.);
run;

Expected Result:

MC062:

60

0

1432

So do you have a generic rule for how to differentiate between when 60.00 is displayed as 60 and 14.32 as 1432?

I could not tell what I would have to do if the value was 55.55 or 66.00 or anything else. We need an explicit generic rule unless your data only consists of those three values.

Do you expect the result to be a numeric value or a character value?

And likely if the value were numeric to start with it will be easier to implement. Also since your example code reads the values as 10 characters you might want to provide longer values if they are encountered as you may have yet more rules not yet stated if the bill_amt is something like 1,234.00

Re: Formatting a field, removing the decimals

Anmolkhandelwal — Mon, 08 Apr 2019 16:00:41 GMT

No generic Rule as such. Just the decimal has to be removed from the given value.

if the value is 55.55: has to be displayed as 5555 or if the value is 66.00 the value i want to output is 66.

the result can be in numeric format.

Re: Formatting a field, removing the decimals

tomrvincent — Mon, 08 Apr 2019 16:02:15 GMT

Check to see if the number = int(number).
If it does, format it with no decimal point. Otherwise, do.

Re: Formatting a field, removing the decimals

novinosrin — Mon, 08 Apr 2019 16:04:23 GMT

HI @Anmolkhandelwal

data input_dataset;
input srno $ bill_amt $10.;
datalines;
1 60.00
2 0.00
3 14.32
;
run;

data want;
set input_dataset;
k=input(bill_amt,8.);
if k ne 0 then k1=k/int(k);
 want=ifn(k1 ne 1 ,k*100,k);
 drop k:;
run;

Re: Formatting a field, removing the decimals

Anmolkhandelwal — Mon, 08 Apr 2019 16:04:28 GMT

Doesn't Work

Re: Formatting a field, removing the decimals

novinosrin — Mon, 08 Apr 2019 16:05:53 GMT

@Anmolkhandelwal Since you mentioned "the result can be in numeric format." I have kept the result want variable as numeric.

Re: Formatting a field, removing the decimals

tomrvincent — Mon, 08 Apr 2019 16:27:18 GMT

data input_dataset;
input srno bill_amt ;
format bill_amt2 $20.;
if bill_amt = int(bill_amt) then bill_amt2 = put(bill_amt,10.); else bill_amt2=put(bill_amt,10.2);
datalines;

Re: Formatting a field, removing the decimals

Kurt_Bremser — Mon, 08 Apr 2019 16:32:37 GMT

@Anmolkhandelwal wrote:

No generic Rule as such. Just the decimal has to be removed from the given value.

if the value is 55.55: has to be displayed as 5555 or if the value is 66.00 the value i want to output is 66.

the result can be in numeric format.

Then why would 14.32 end up as 1432 (as stated in your initial post)?

Re: Formatting a field, removing the decimals

ballardw — Mon, 08 Apr 2019 16:38:36 GMT

@Anmolkhandelwal wrote:

No generic Rule as such. Just the decimal has to be removed from the given value.

if the value is 55.55: has to be displayed as 5555 or if the value is 66.00 the value i want to output is 66.

the result can be in numeric format.

That further example sounds a whole lot like "if the decimal portion is 00 then remove, else remove the decimal point"

Which this may help with:

data input_dataset;
   input srno $ bill_amt $10.;
   length mc062 $ 10;
   if index(bill_amt,'.00')>0 then mc062 = scan(bill_amt,1,'.');
   else if index(bill_amt,'.')>0 then mc062 = transtrn(bill_amt,'.',trimn(""));
datalines;
1 60.00
2 0.00
3 14.32
;
run;

Re: Formatting a field, removing the decimals

novinosrin — Mon, 08 Apr 2019 16:45:09 GMT

@ballardw Clever as always 🙂 You don't have blood in your veins. It's all brains. Well done!

Re: Formatting a field, removing the decimals

Tom — Mon, 08 Apr 2019 16:51:52 GMT

I don't understand why you would do this.

How are you going to tell the difference between 1.23 and 123 ?

Re: Formatting a field, removing the decimals

ballardw — Mon, 08 Apr 2019 20:52:00 GMT

Doesn't work is awful vague.

Are there errors in the log?: Post the code and log in a code box opened with the {i} to maintain formatting of error messages.

No output? Post any log in a code box.

Unexpected output? Provide input data in the form of data step code pasted into a code box, the actual results and the expected results. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

Re: Formatting a field, removing the decimals

Ksharp — Tue, 09 Apr 2019 14:41:43 GMT

data input_dataset;
input srno $ bill_amt $10.;
datalines;
1 60.00
2 0.00
3 14.32
;
run;

 

data test;
set input_dataset;
format mc062 $10.;
mc062 = compress(prxchange('s/\.0+$//',1,strip(bill_amt) ),'.');
run;

Re: Formatting a field, removing the decimals

burksmiv — Wed, 14 Apr 2021 12:52:35 GMT

Hello,

How do you remove decimals and insert commas for non-currency numbers?

Re: Formatting a field, removing the decimals

Kurt_Bremser — Wed, 14 Apr 2021 12:56:05 GMT

Just change the display format.

data want;
x = 12345.789;
format x comma10.;
run;

If you do not want the value to be rounded, apply the INT() function first.