Mike You have to create a variable that includes the parens to use it with IN:
SET VAR VTPR_MELT TEXT = '(435-10,436-11)' Then the command is: TALLY ITEM_NO FROM SHIPMAST WHERE SHIPDATE BETWEEN 1/1/2009 AND 12/15/2009 AND MELTCODE IN &VTPR_MELT AND SX_FLAG = 'SHIP' David "David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261" -----Original Message----- From: Ramsour Mike [mailto:[email protected]] Sent: Wednesday, December 16, 2009 09:37 PM To: 'RBASE-L Mailing List' Subject: [RBASE-L] - TALLY behavior 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 NoticeThis 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.
