Convert Character to Numberic in data step

[tobyfarms]

I've tried several solutions on here but I can't quite get the result needed.

I am preparing to merge 2 tables, but before so I need to convert 10 fields from character to numeric.  

The error code that provoked this cry for help is.   ERROR: Variable TMP has been defined as both character and numeric.

I am trying to get the variables TMP and DPT to change to numeric values, but depending on the format that I pick (best8, $char, etc) I will either get blanks or dots in the results.

Code is as follows:

data updt_data

updt_forecast;

set weath_updt;

if status = "O" then output updt_data;

else output updt_forecast;

tmp_new=input(TMP,best8.);

dpt_new=input(DPT,best8.);

drop TMP;    Rename tmp_new=TMP;

drop dpt;      Rename dpt_new=DPT;

run;

[data_null__ · Accepted solution]

Looks like you are OUTPUTing before you assign the new variables a value.

[tobyfarms]

A simple misstep can throw off the entire code.  Issue fixed, thanks @data_null__