I'm trying to merge two datasets that have injury information. However, I keep getting an error message that the variable contains both character and numeric values. Here is my code: libname injury "X:\filedirectory"; proc sort data=injury.victim; by ID; run; proc sort data=injury.pdo; by I_D; run; data pdo; set injury.pdo(rename=(I_D=ID)); run; data victim_pdo; Merge victim pdo; by ID; run; I've looked up this problem and tried to convert the variable "ID" in both datasets to numeric: data pdo; set injury.pdo; ID=input(ID,8.); put ID; run; data victim; set injury.victim; ID=input(ID,8.); put ID; run; data victim_pdo; Merge victim pdo; by ID; run; This didn't work, as I'm still getting the same error message. Please help!
... View more