Hi! I am a new-ish SAS user. I am trying to do a one-to-many data merge with two files in my work folder. However, I keep getting this error: ERROR: Variable Type has been defined as both character and numeric. However, the varaibles are exactly the same: Name: NUMBER Length: 8 Format: Best12 Informat: 12 Type: Numeric I have tried multiplying NUMBER by one to be sure it is numeric or to see if it needed a reset of sorts, but that did not work my sas code is this: /* Sorting data and merging */ proc sort data = A; by NUMBER; run; proc sort data = B; by NUMBER; run; /*One to many data merge - NUMBER is numeric */ data Merged_A_B; merge A (in = aaa) B (in = bbb); by NUMBER; if aaa*bbb = 0 then delete; run; I am thinking it may be how I am merging and I have looked online for help but was not able to find it. Help with this would be much appreciated! C
... View more