On 28-Jul-2005, [EMAIL PROTECTED] (Frank Yaeger) wrote: > For closure: Howard sent me his input data offline. With this more > extensive set of input data, I was able to see more clearly what he was > trying to do. He had non-duplicate records in his input file, which I > hadn't realized from the smaller input sample. That meant he needed to use > LAST instead of LASTDUP. LASTDUP only gives you the last record of each > set of duplicates. LAST gives you the last record of each set of > duplicates AND the non-duplicate records. This gave Howard the output he > wanted.
That worked, thanks. Nothing like having appropriate test data. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
