How to create a numeric variable by taking numeric portion of a character variable

knveraraju91 — Sun, 28 Aug 2016 01:50:23 GMT

Dear,

I have a variable 'TPT' containing numbers and text. I need to create a numeric variable (TPTNUM) from numeric portion of TPT. Please help

TPT

0.5 hours

1 hour

1.5 hours

2 hours

2.5 hours

output needed;

0.5

1.5

2.5

Thank you

Re: How to create a numeric variable by taking numeric portion of a character variable

PGStats — Sun, 28 Aug 2016 02:28:32 GMT

If the number is the first part of the field:

TPTNUM = input(scan(TPT, 1, " "), best.);