Usage Note 14903: "ERROR: No BY statement used or no BY variable specified" with NODUP
option in PROC SORT
When you eliminate exact duplicate records where every variable is
identical by using a PROC SORT with the NODUPRECS (that is, NODUP)
option, the following error message might appear:
ERROR: No BY statement used or no BY variables specified. A BY
statement must be used with variable names to sort on.
Include the BY_ALL_ statement after the PROC SORT statement. For
example:
proc sort data=all out=one noduprecs;
by _all_;
Operating System and Release Information
| SAS System | Base SAS | Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | |
| Microsoft Windows XP Professional | 9.1 TS1M3 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | |
| Microsoft Windows 2000 Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | |
| Topic: | Common Programming Tasks ==> Sorting Data
SAS Reference ==> Procedures ==> SORT
|
| Date Modified: | 2005-04-20 16:36:13 |
| Date Created: | 2005-04-01 16:09:39 |
