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__
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.