Certain data set options cause warning or errors and are not honored.

Below are some of the warnings or errors you may get.

   WARNING:  The variable  in the DROP, KEEP, or
   RENAME list has never been referenced.
  

• The WHERE data set option is honored.
• The KEEP and DROP data set options cause warnings.

A fix is planned for a future release.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	Base SAS	z/OS	9.2 TS1M0	9.3 TS1M0
		Microsoft® Windows® for 64-Bit Itanium-based Systems	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows Server 2003 Datacenter 64-bit Edition	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows Server 2003 Enterprise 64-bit Edition	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows XP 64-bit Edition	9.2 TS1M0	9.3 TS1M0
		Microsoft® Windows® for x64	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows Server 2003 Datacenter Edition	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows Server 2003 Enterprise Edition	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows Server 2003 Standard Edition	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows Server 2008	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows XP Professional	9.2 TS1M0	9.3 TS1M0
		Windows Vista	9.2 TS1M0	9.3 TS1M0
		64-bit Enabled AIX	9.2 TS1M0	9.3 TS1M0
		64-bit Enabled HP-UX	9.2 TS1M0	9.3 TS1M0
		64-bit Enabled Solaris	9.2 TS1M0	9.3 TS1M0
		HP-UX IPF	9.2 TS1M0	9.3 TS1M0
		Linux	9.2 TS1M0	9.3 TS1M0
		Linux for x64	9.2 TS1M0	9.3 TS1M0
		OpenVMS on HP Integrity	9.2 TS1M0	9.3 TS1M0
		Solaris for x64	9.2 TS1M0	9.3 TS1M0

* 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.

This code stops running after the DROP data set option is attempted.

---

data _null_;
   length k 8;
   length d $10;
   declare hash h(ordered: 'y');
   h.defineKey('k');
   h.defineData('k', 'd');
   h.defineDone();
   k = 99;
   d = 'abc';
   h.add();
   k = 199;
   d = 'def';
   h.add();
   h.output(dataset: 'work.x (where=(k=99))');
   h.output(dataset: 'work.y (drop=k) ');
 run;

SAS LOG:
1    data _null_;
2       length k 8;
3       length d $10;
4       declare hash h(ordered: 'y');
5       h.defineKey('k');
6       h.defineData('k', 'd');
7       h.defineDone();
8       k = 99;
9       d = 'abc';
10      h.add();
11      k = 199;
12      d = 'def';
13      h.add();
14      h.output(dataset: 'work.x (where=(k=99))');
15      h.output(dataset: 'work.y (drop=k) ');
16   run;

NOTE: The data set WORK.X has 1 observations and 2 variables.
WARNING: The variable k in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: The data set WORK.Y has 2 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.06 seconds
      cpu time            0.04 seconds
      

      


                          work.x (where=(k=99))                         1

                            Obs     k     d

                             1     99    abc


                             work.y (drop=k)                            2

                           Obs     k      d

                            1      99    abc
                            2     199    def

Certain data set options cause warning or errors and are not honored.

Type:	Problem Note
Priority:	high
Topic:	SAS Reference ==> Component Objects ==> hash object ==> OUTPUT

Date Modified:	2011-06-06 14:12:16
Date Created:	2009-09-28 16:17:39