character to numeric with trailing zero

[jenim514]

Hi!

I have some character values for varialbe FlightHrs

1.2   new format  => 1.20

1.30 => 1.30

1.42 => 1.42

1.3 =>    1.30

I would like to make all the values numeric format (4.2?) with added zero at the end if missing.

I tried this, but no success

flighthrs=input(flighthrs,4.2);

Thanks you!

[Reeza]

format flghthrs 8.2;

[PaigeMiller · Accepted solution]

YYou can't really convert a character variable to a numeric variable.

You can, however, create a new numeric variable that has the values (properly formatted) of the character variable.

	flighthrs1=flighthrs+0;
	format flighthrs1 4.2;