I keep running up against the defined format. I've tried converting the numeric variable back to a character using the BEST format then BACK to a numeric but I keep losing precision.
An example. I've converted these character variables to numeric variables:
character variables --> converted to --> numeric variables
49.9568 sq. cm 49.9568000
50.3701 sq. cm 50.3701000
6.43636 sq. cm 6.4363600
4.48661 sq. cm 4.4866100
0.0297726 sq. cm 0.0297726
Now, I need to remove those trailing zeros, yet keep the variable a numeric variable and not loose any precision. I need them to look like:
but still remain numbers.
Any suggestions would be greatly appreciated.