In my example, cptcodes change over the course of several years, but
the name of the service does not. What I would like is for Rbase to
return the value of the cptcode that was associated with (in the same
row as) the most recent service.
Michael Sinclair, MD
www.epilution.com
(\__/)
(='.'=)
(")_(")
On Oct 25, 2009, at 9:29 PM, Lawrence Lustig <[email protected]>
wrote:
<<
I think this will work! Is it possible to add another column
(cptcode) to what is displayed without adding it to the group by
clause?
>>
All columns must be EITHER included in the GROUP BY clause OR ELSE
wrapped in a aggregate function (MIN, MAX, COUNT, STD, AVG, or
LISTOF). Otherwise, how would R:Base know which of several values
to report back to you?
--
Larry
