I am facing a problem with my labs dataset. There is a choice of 10 different units to choose from for reporting WBC values. the format used is 11.3(w.d). so some values are 11300.000 * 10^3/cumm which actually should be 11.300 * 10^3/cumm.
I seperated all the units into different datasets. but changing the format is not helping and the records are frozen so they can only be changed in the program.
Can any one help me as to how can I aproach the problem and have all the values in 6.3 format.
There are 2 columns one with the value for wbc another with unit. there are 12 different types to choose from so the way it looks is Col1:14.500 col2:10^3/ul
so the problem is that these values are wrong for certain subjects in terms of their decimals. We cannot apply same program to deal with all the values in a dataset. My problem is what can be done in terms of programming that takes care of the wrong values like some values look like 1130.000 or 140.000, they have been entered wrong. I hope this is understandable.