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;
A simple misstep can throw off the entire code. Issue fixed, thanks @data_null__
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.