topic Re: character to numeric with trailing zero in SAS Programming

character to numeric with trailing zero

jenim514 — Fri, 28 Jul 2017 15:32:04 GMT

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 — Fri, 28 Jul 2017 15:34:14 GMT

format flghthrs 8.2;

PaigeMiller — Fri, 28 Jul 2017 15:35:54 GMT

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;