Hi,

I have a column containing different number and weights for grocery products (weights). Some products have the value of round numbers ( 1, 2,13) and I want to maintain these, but I would like the values that are not round numbers to be changed to one.

For instance a weight like .23 should be one and the same for 2.78.

As all the numbers I want to change have a "." in common, I tried the following command;

replace weights =1 if weights ==.

This did not work. Does anyone have a clue what might work?

Thanks
Terje