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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.