Date:         Mon, 20 Nov 2000 15:54:15 -0500
Reply-To:     "Alan H. McArdle" <amcardle@OIRP.UMASS.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Alan H. McArdle" <amcardle@OIRP.UMASS.EDU>
Subject:      Precision/rounding problems across platforms
Content-type: text/plain; charset=iso-8859-1

Thanks to 'Doc' Muhlbaier for spotting the flaw in my code. This was not a
precision problem but a collating sequence problem. IBM and PC have
different sorting sequences and I was doing LT and GE comparisons with data
that was mostly numeric but could be alpha as well. The quick and dirty fix
was to enumerate the possible values with an IN operator instead of a
logical comparison. Problem solved.

Thanks to the other folks who responded, as well.

Alan H. McArdle, Associate Director Analytic Studies
Office of Institutional Research
237 Whitmore
University of Massachusetts Amherst
Amherst, MA 01003
Voice: 413-545-5149
Fax:   413-545-3010