I have been using a mid-1980s version of Rbase for almost 30 years, and recently upgraded to eXtreme 9.5.
I recently discovered what seems to be an anomoly with the TALLY command. It appears that if a column contains a long value, TALLY doesn't work as expected. Example: The table TEMP1 contains a single column (text 255), and three unique rows. Here, TALLY works as I'd expect it to: R>SEL ALL FRO TEMP1 XCOL ----------------------------------------------------------------------------- 000000000000000000000000000000_001 000000000000000000000000000000_002 000000000000000000000000000000_003 R>TALLY XCOL FRO TEMP1 XCOL Number of Occurrences ---------------------------------------------- --------------------- 000000000000000000000000000000_001 1 000000000000000000000000000000_002 1 000000000000000000000000000000_003 1 However, if the fields contain longer strings (here, I've duplicated the table, and added 10 more characters in each field), TALLY gives the following results: Three occurrences of a single column value, rather than three separate values and one occurrence for each value: R>SEL ALL FRO TEMP2 XCOL ----------------------------------------------------------------------------- 0000000000000000000000000000000000000000_001 0000000000000000000000000000000000000000_002 0000000000000000000000000000000000000000_003 R>TALLY XCOL FRO TEMP2 XCOL Number of Occurrences ---------------------------------------------- --------------------- 0000000000000000000000000000000000000000 3 I'm aware that the visible TALLY results are truncated when fields contain long strings (is there any way to see the full value?), but still, I would expect to see three rows in the results, not one row. In other words, I'd expect to see this: R>TALLY XCOL FRO TEMP2 XCOL Number of Occurrences ---------------------------------------------- --------------------- 0000000000000000000000000000000000000000 1 0000000000000000000000000000000000000000 1 0000000000000000000000000000000000000000 1 Thanks in advance for any help provided. Patty
