DATA Step, Macro, Functions and more

character to numeric with trailing zero

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 142
Accepted Solution

character to numeric with trailing zero

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!


Accepted Solutions
Solution
‎07-28-2017 11:46 AM
Trusted Advisor
Posts: 1,918

Re: character to numeric with trailing zero

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;

View solution in original post


All Replies
Super User
Posts: 19,805

Re: character to numeric with trailing zero

format flghthrs 8.2;
Solution
‎07-28-2017 11:46 AM
Trusted Advisor
Posts: 1,918

Re: character to numeric with trailing zero

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;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 75 views
  • 0 likes
  • 3 in conversation