LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (March 2008, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Wed, 5 Mar 2008 08:31:59 -0800
Reply-To:   reddy <mail2karna@GMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   reddy <mail2karna@GMAIL.COM>
Organization:   http://groups.google.com
Subject:   Re: merge and length problem urgent please
Comments:   To: sas-l@uga.edu
Content-Type:   text/plain; charset=ISO-8859-1

On Mar 5, 8:22 am, Eversmann <rifazraz...@gmail.com> wrote: > Hi. > > Note a good idea to have different lengths for the vars used to > merge.as pointed out by SAS it could cause erroneous results. > > Why not change the length in one input dataset to fit the other (i.e. > $10 in both). > > Or am I not understanding the question correctly? > > On Mar 5, 4:12 pm, reddy <mail2ka...@gmail.com> wrote: > > > > > Hi All > > > i am varying lengths in two datasets and merging them it is giving > > below warning,I am using mainframes too it is giving warning message > > client wont accept those warning messages right.... We cant tap and > > hide the errors please please give me the solution.......... > > > data q ; > > length x $1 ; > > x = "abcdefghij" ; > > run ; > > > data w ; > > length x $10 ; > > x = "abcdefghij" ; > > run ; > > > data qw ; > > merge q w ; > > by x ; > > run ; > > > ---------------------------------------------------------------------------­----------------------------------- > > > WARNING: Multiple lengths were specified for the BY variable x by > > input > > data sets. This may cause unexpected results. > > NOTE: There were 1 observations read from the data set WORK.Q. > > NOTE: There were 1 observations read from the data set WORK.W. > > NOTE: The data set WORK.QW has 1 observations and 1 variables. > > NOTE: DATA statement used (Total process time): > > real time 0.00 seconds > > cpu time 0.00 seconds > > > Thnaks& regards, > > Karunakar > > mail2ka...@gmail.com- Hide quoted text - > > - Show quoted text -

Thanks for responding dont look about varying length think about code ..... and requirment is like that we cant make it length 10 to first dataset.....


Back to: Top of message | Previous page | Main SAS-L page