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__
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: