Date: Fri, 1 Oct 1999 16:16:22 GMT
Reply-To: ray <dh42714@GOODNET.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: ray <dh42714@GOODNET.COM>
Organization: WinStar GoodNet, Inc.
Subject: Re: merging problems
Content-Type: text/plain; charset=us-ascii
Dear Tim: Thanks for the reply. I followed your instruction and checked both
data sets. In one data set, the cnum variable shows a length of 8 and in the
other it shows a length of 12. This is surprising since I used the same substr
function on both datasets. Do you know where I might find information explaining
how to change the variable length. Thanks once again.
"Berryhill, Tim" wrote:
> Ray, The simplest I way I can imagine for this to be true is that CNUM
> already existed with some other length in one of the two files when you
> "created" it. I suggest you run PROC CONTENTS on each dataset to find which
> CNUM is not $6, and then inspect the code.
> Tim Berryhill - Contract Programmer and General Wizard
> TWB2@PGE.COM or http://www.aartwolf.com/twb.html
> Frequently at Pacific Gas & Electric Co., San Francisco
> The correlation coefficient between their views and
> my postings is slightly less than 0
> > ----------
> > From: ray[SMTP:dh42714@GOODNET.COM]
> > Reply To: ray
> > Sent: Thursday, September 30, 1999 10:49 PM
> > To: SAS-L@LISTSERV.UGA.EDU
> > Subject: merging problems
> > Dear Sas-sers:
> > I have two data sets that I am trying to merge by a variable called
> > CNUM. Now the variable CNUM is a substring of a character variable which
> > I created as follows for both data sets: cnum=substr(cus,1,6). My first
> > data consists of 200 observations and the other 700. My goal is to
> > obtain relevant variables from the larger database and include them to
> > my 200 sample. Now the problem is I keep getting the following warning
> > message:
> > ' WARNING: Multiple lengths were specified for the BY variable CNUM by
> > input data sets.
> > This may cause unexpected results.'
> > On checking the merged set, I found about 100 duplicate records. Can
> > someone clue me in on a possible remedy.
> > ray