Hey All,  I an new at SAS and also in this forum, but i hope someone can help me.  i need to merge to different file by variable TikID    here is the code:  PROC IMPORT OUT= WORK.nesibot_2 DATAFILE= "C:\sasdata\2017\nesibot_2.xlsx" DBMS=xlsx rePLACE; GETNAMES=YES; RUN; data TIK_2010_2016; merge TIK_2010_2016 nesibot_2; by TikId shana; run; and here is the log:  data TIK_2010_2016; 361 merge TIK_2010_2016 nesibot_2; ERROR: Variable TikId has been defined as both character and numeric. 362 by TikId shana; 363 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.TIK_2010_2016 may be incomplete. When this step was stopped there were 0 observations and 17 variables. WARNING: Data set WORK.TIK_2010_2016 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.03 seconds   ... View more