10-23-2017 10:39 AM
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:
if status = "O" then output updt_data;
else output updt_forecast;
drop TMP; Rename tmp_new=TMP;
drop dpt; Rename dpt_new=DPT;
Need further help from the community? Please ask a new question.