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!
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;
format flghthrs 8.2;
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.