Hi All - Thank you in advance for your response.
As a new user, I've successfully used the proc import function to import my excel data. A variable was imported as a character data type and I tried to convert it to numeric. I successfully converted the variable data type, but only in a manner that drops all other variables of interest that already have the correct data type. Trying to use the new_var=input(ori_var, informant) structure with the set and keep statements does not work. I've tried moving the new variable statement before and after the keep statement without success. Below is an example with the two locations I've tried adding the new variable language (commented out). Hope this makes sense! Ultimately, to solve the issue, I had to go back to the original excel file and delete the null data that was causing the issue... In the future I'd love to solve this within the SAS environment.
data user.base;
set work.base;
*Pb=input(pb_mg_kg,best.);
keep unique_ID siteID StateID CollDate Recreation Food_production Residential Urbanized_area Non_urbanized green_space forests State mg_kg;
*Pb=input(pb_mg_kg,best.);
run;
Thanks, again for some insight!
... View more