Good evening:
Is this the correct behavior for the TALLY command?
============================
Parameters:
ITEM_NO column data type: INTEGER
Variable = Value Type
------------------ ------------------------------ -------
VTPR_MELT = 435-10,436-11 TEXT
============================
This commands gives this result:
TALLY ITEM_NO FROM SHIPMAST WHERE SHIPDATE BETWEEN 1/1/2009 AND 12/15/2009
AND MELTCODE IN ( &VTPR_MELT ) AND SX_FLAG = 'SHIP'
<WARNING> No rows exist or satisfy the specified clause. (2059)
Whereas only changing "MELTCODE IN ( &VTPR_MELT )" to "MELTCODE IN
(435-10,436-11)", i.e. replacing the variable with hard-coded values gives
the expected result:
R>TALLY ITEM_NO FROM SHIPMAST WHERE SHIPDATE BETWEEN 1/1/2009 AND 12/15/2009
AND MELTCODE IN (435-10,436-11) AND SX_FLAG = 'SHIP'
ITEM_NO Number of Occurrences
----------------- ---------------------
141758 5
143077 6
143206 4
143272 2
143341 3
144400 66
blah
blah
blah
============================
Both examples copied and pasted directly from the R>.
CROSSTAB works correctly with or without the use of the variable. Am I
missing something?
Mike Ramsour
Confidentiality Notice
This message is intended exclusively for the individual or entity to which it
is
addressed and may contain privileged, proprietary, or otherwise private
information.
If you are not the named addressee, you are not authorized to read, print,
retain,
copy or disseminate this message or any part of it. If you have received this
message in error, please notify the sender immediately by e-mail and delete all
copies of the message.
