Date:         Mon, 23 May 2011 08:49:19 -0700
Reply-To:     oslo <oslo@yahoo.com>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         oslo <hokut1@YAHOO.COM>
Subject:      Re: Import and merge problem
Comments: To: Jim Groeneveld <jim.1stat@yahoo.com>
In-Reply-To:  <201105221125.p4MAnm6x020539@willow.cc.uga.edu>
Content-Type: text/plain; charset=iso-8859-1

Dear Jim;

Thanks a lot. It is much appreciated.

Regards,

Oslo




________________________________
From: Jim Groeneveld <jim.1stat@YAHOO.COM>
To: SAS-L@LISTSERV.UGA.EDU
Sent: Sun, May 22, 2011 6:25:34 AM
Subject: Re: Import and merge problem

Hi Oslo,

Take care to set sufficient lengths for both variables before merging:

data all;
  LENGTH SireID DamID $ 256; * sufficient length;
  merge a b; byID;
run;

Regards - Jim.



On Sat, 21 May 2011 23:44:35 -0700, oslo <hokut1@YAHOO.COM> wrote:

>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