Consider using a temp table and project your results first. Then Tally. Even include other information also if wanted.
I prefer to see my results (check for any errors that I forgot or included) first then to proceed. JM.02 Paul D. From: [email protected] [mailto:[email protected]] On Behalf Of Ramsour Mike Sent: Wednesday, December 16, 2009 9: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 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.
