This code may be useful in indicating which variable/datasets you need to be concerned with. It will create a report table with an X indicating which datasets have a variable of which type.
proc format library=work;
value x
1='X'
;
proc tabulate data=sashelp.vcolumn;
where libname='AHCA';
class memname name type;
tables name*type,
memname*n=''*f=x.
/misstext=' ';
run;
If these sets came from a common structure and were read with proc import then you may want to go back to reading the data with a method that will set consistent types and lengths.
Your error is likely to have issues with data truncation do to length differences as well.
... View more
