DATA Step, Macro, Functions and more

Convert Character to Numberic in data step

Accepted Solution Solved
Reply
Contributor
Posts: 44
Accepted Solution

Convert Character to Numberic in data step

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;

 


Accepted Solutions
Solution
‎10-23-2017 10:49 AM
Respected Advisor
Posts: 3,799

Re: Convert Character to Numberic in data step

Posted in reply to tobyfarms
Looks like you are OUTPUTing before you assign the new variables a value.

View solution in original post


All Replies
Solution
‎10-23-2017 10:49 AM
Respected Advisor
Posts: 3,799

Re: Convert Character to Numberic in data step

Posted in reply to tobyfarms
Looks like you are OUTPUTing before you assign the new variables a value.
Contributor
Posts: 44

Re: Convert Character to Numberic in data step

Posted in reply to data_null__

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 107 views
  • 0 likes
  • 2 in conversation