DATA Step, Macro, Functions and more

character to numeric with trailing zero

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 121
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
3 weeks ago
Trusted Advisor
Posts: 1,613

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: 17,819

Re: character to numeric with trailing zero

format flghthrs 8.2;
Solution
3 weeks ago
Trusted Advisor
Posts: 1,613

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
  • 64 views
  • 0 likes
  • 3 in conversation