Hello, I am using SAS 9.4 (English). I am using proc sql to create a table. Here is my question: Other than type, do the variable attributes (length, format, informat) of the matching variables have to be identical in each dataset? For example, consider the following code: proc sql;
create table data3
as select a.*, b.*
from data1 as a left join data2 as b
on a.var1 = b.var1 order by var1, year; quit; Suppose that var1 in data1 and var1 in data2 are both numeric (type) but differ in length, format, and informat. Would I still be able to create a table from data1 and data2? Or would I have to make sure that length, format, and informat are identical as well? Thanks for the help. Tristan
... View more
