Date: Wed, 25 Feb 1998 00:49:04 -0500
Reply-To: S David Riba <dave@JADETEK.COM>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: S David Riba <dave@JADETEK.COM>
Subject: Does anyone have a rational explanation for this one?
Content-Type: text/plain; charset="iso-8859-1"
I encountered this problem today and it contradicts everything
I *thought* I knew about the SAS Data step. Anyone care to
shed some light on what happened here?
The job was a batch job run on SAS Version 6.12 for Windows NT.
The BY variable is character in both datasets with a length of 5.
1892 proc sort data=name ;
1893 by isrid ;
1894 run ;
NOTE: The data set WORK.NAME has 651 observations and 5 variables.
NOTE: The PROCEDURE SORT used 0.52 seconds.
1895 data name ;
1896 set name ;
1897 by isrid ;
1898 if last.isrid ;
1899 run ;
NOTE: The data set WORK.NAME has 650 observations and 5 variables.
NOTE: The DATA statement used 0.28 seconds.
1900
1901 proc sort data=sales1 ;
1902 by isrid ;
1903 run ;
NOTE: The data set WORK.SALES1 has 95661 observations and 72 variables.
NOTE: The PROCEDURE SORT used 2 minutes 5.83 seconds.
1904
1905 data sales2 ;
1906 merge sales1 (in=a)
1907 name ;
1908 by isrid ;
1909 if a ;
1910 run &cancel;
ERROR: BY variables are not properly sorted on data set WORK.SALES1.
ERROR: BY variables are not properly sorted on data set WORK.SALES1.
ERROR: BY variables are not properly sorted on data set WORK.SALES1.
(note: data dump removed for confidentiality reasons)
FIRST.ISRID=0 LAST.ISRID=0 _ERROR_=1 _N_=80303
NOTE: The SAS System stopped processing this step because of errors.
NOTE: SAS set option OBS=0 and will continue to check statements. This may
cause NOTE: No observations in data set.
WARNING: The data set WORK.SALES2 may be incomplete. When this step was
stopped there were 80198 observations and 76
variables.
NOTE: The DATA statement used 48.64 seconds.
----------------------------------------------------------------------------
S. David Riba INTERNET: dave@JADETEK.COM
JADE Tech, Inc. http://www.jadetek.com
P O Box 4517
Clearwater, FL 33758
VOICE: (813) 726-6099 A SAS Institute Quality Partner
SAS. It's not just an attitude
