Convert Character to Numberic in data step

tobyfarms — Mon, 23 Oct 2017 14:39:24 GMT

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;

Re: Convert Character to Numberic in data step

data_null__ — Mon, 23 Oct 2017 14:45:38 GMT

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

Re: Convert Character to Numberic in data step

tobyfarms — Mon, 23 Oct 2017 14:50:03 GMT

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

topic Re: Convert Character to Numberic in data step in SAS Programming

Convert Character to Numberic in data step

Re: Convert Character to Numberic in data step

Re: Convert Character to Numberic in data step