Date:         Sat, 21 May 2011 23:44:35 -0700
Reply-To:     oslo <oslo@yahoo.com>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         oslo <hokut1@YAHOO.COM>
Subject:      Import and merge problem
Content-Type: text/plain; charset=iso-8859-1

Dear All;

Suppose I do import two data sets then merge them as follow;
proc
datafile='C:\Users\AA.xls'DBMS
GETNAMES=YES;
DATAROW=
GUESSINGROWS==xls 
REPLACE;2;30;RUN;procimportout=work.bdatafile='C:\Users\BB.xls'DBMS
GETNAMES=YES;
DATAROW=
GUESSINGROWS==xls REPLACE;2;30;RUN;procsortdata= a;byID; run;procsortdata= 
b;byID; run;dataall;mergea b;byID;run
 
After this I am getting this the following warning: 
WARNING: Multiple lengths were specified for the variable SireID by input data 
set(s). This may
cause truncation of data.
WARNING: Multiple lengths were specified for the variable DamID by input data 
set(s). This may
cause truncation of data.
 
So How I can overcome with this warning.
 
Regards,
 
Oslo
 ;importout=work.a