i'm trying to perform a one to one merge to link two datasets with a uniqueid (common key) that is a text veriable. these data currently reside as two separate Excel files and i use the IMPORT function. the issue i've encountered is that in one dataset the uniqueid is 8 characters long and in the other it is 30 characters long (excel formatting?). is there a way to specify var length when importing data from an excel file? thanks in advance. dawn ... View more