Date:         Mon, 13 Oct 1997 14:42:37 +0200
Reply-To:     Maria Blanke <mblanke@IX.URZ.UNI-HEIDELBERG.DE>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Maria Blanke <mblanke@IX.URZ.UNI-HEIDELBERG.DE>
Subject:      LOG/FILE1
Content-Type: TEXT/PLAIN; charset=US-ASCII

 <Pine.A41.3.96.971013144201.26766B-100000@aixterm3.urz.uni-heidelberg.de>
X-LSVTag: Mime-Version: 1.0
X-LSVTag: Content-Type: TEXT/PLAIN; charset=US-ASCII
To:           $PEER$ <SAS-L@VTVM1.CC.VT.EDU>
 
Dear SAS/L,
 
can anyone help me with the following two files. Here the first is
ignoring theif / then commands and matching the rows not properly
together, although that
the id variable is sorted
just that each value
is occuring 20 times
and alsoI have checked that the number of lines isfitting together and are
homogen, just the number of columns is differentlz, but I don|t think
thatthis is the reason.
Has anyone an idea, what I can do to go forward with my Datas?
Thanks a lot.
 
Maria Michaela
 
 
 
> 1    Data one;
> 2
> 3    infile cards missover;
> 4    input a v w id l w n1 n2 n3 WS1 WS2 n4 n5 n6;
> 5
> 6    if n4='' then n4=0;
> 7    if n5='' then n5=0;
> 8    if n6='' then n6=0;
> 9
> 10   cards
> 11   ;
>
> NOTE: Character values have been converted to numeric
>       values at the places given by: (Line):(Column).
>       6:7   7:7   8:7
> NOTE: The data set WORK.ONE has 1281 observations and 13 variables.
> NOTE: DATA statement used:
>       real time           2.45 seconds
>       cpu time            0.28 seconds
>
>
> 1293  ;
> 1294  run;
> 1295
> 1296  Data two;
> 1297  input obs a x y id lx ly dx dy f;
> 1298
> 1299  cards
> 1300  ;
>
> NOTE: The data set WORK.TWO has 1280 observations and 10 variables.
> NOTE: DATA statement used:
>       real time           0.92 seconds
>       cpu time            0.20 seconds
>
>
> 2581  ;
> 2582  run;
> 2583
> 2584  Data three;
> 2585  merge one two;
> 2586  by id; run;
>
> ERROR: BY variables are not properly sorted on data set WORK.ONE.
> A=20 V=2 W=5 ID=65 L=8 N1=5 N2=6 N3=3 WS1=3 WS2=0 N4=0 N5=0 N6=0 OBS=1280 X=2
> Y=4 LX=2 LY=4 DX=0 DY=0 F=0 FIRST.ID=0 LAST.ID=0 _ERROR_=1 _N_=1280
> NOTE: MERGE statement has more than one data set with repeats of BY values.
> NOTE: The SAS System stopped processing this step because of errors.
> WARNING: The data set WORK.THREE may be incomplete.  When this step was
>          stopped there were 1279 observations and 21 variables.
> NOTE: DATA statement used:
>       real time           1.05 seconds
>       cpu time            0.15 seconds
>
>
> 2587
> 2588  Proc Print; run;
>
> NOTE: PROCEDURE PRINT used:
>       real time           0.68 seconds
>       cpu time            0.20 seconds
>
>
>
> --
> ***********************************************
> *         Maria Michaela Habram-Blanke        *
> *             TelFAX: 0622120311              *
> *    Email: mblanke@ix.urz.uni-heidelberg.de  *
> ***********************************************
>
>