How to convert variable from character to numeric when there is one missing value

[gahlot1999]

Data Set - 

How to convert this character dataset to variable. So that I can fetch data out of it....Having issue due to missing value...

Tried - RFICDAT = input(RFICDAT, 10.), RFICDAT = input(RFICDAT, 10.)

[sbxkoenk · Accepted solution]

Use a different variable name on the left hand side of assignment statement :

RFICDATnum = input(RFICDAT, 10.);

Koen

[andreas_lds]

You can't change the type of a variable, you have to create a new one, as shown by @sbxkoenk 

[Kurt_Bremser]

You are importing an Excel spreadsheet where the "header row" seems to be in a non-standard location. PROC IMPORT provides options to deal with this. Please show us a screenshot of the original spreadsheet.

The numbers you see are the raw values of Excel dates.

[gahlot1999]

Hi, here is the screenshot for excel spreadsheet. Could you please let me know how to handle this in proc import directly.

[Kurt_Bremser]

This looks straight forward. How did you import this spreadsheet (please post the complete code)?