A discovery I made today involved joining two datasets with one column ‘ObjectFile’ with different column widths (let’s say the ObjectFile column width for the datasets are 35 and 96).  If my join selected the dataset with the smaller column size (35) first, then the values of my second dataset would be truncated from 96 to 35.  I was using SAS Enterprise Guide 6.1.  Just something to look out for.  Below is what the query looked like:

PROC SQL;
CREATE TABLE MYREP.COMBINED_QUERY1 AS
SELECT *
FROM MYREP.DATASET1
UNION
SELECT *
FROM MYREP.DATASET2
;
QUIT;