[RBG7-L] - Show a count(*) in a CHOOSE

[James Hageman]

I would like to use a CHOOSE to get distinct dates from a dataset and tell 
me how many events are for a date in the CHOOSE is this possible.

I want to take this select and put it in a CHOOSE command.

SELECT ch1_date, COUNT(*) FROM CHANGE1 WHERE CH1_SCHEDULE = 185 GROUP BY 
CH1_DATE
 ch1_date   COUNT (*)  
 ---------- ---------- 
 05/03/1993         11
 05/10/1994          6
 05/04/1995          5
 05/07/1996          2
 01/31/1997          1
 05/12/1997          6
 01/06/1999          1
 05/07/1999          6
 02/24/2000          1
 04/13/2000         12
 07/10/2001          3
 04/29/2002          1
 04/21/2003          2
 05/25/2005          1


Something like :

CHOOSE var_date FROM #VALUES FOR ch1_date, COUNT(*) FROM CHANGE1 + 
WHERE CH1_SCHEDULE = 185 GROUP BY CH1_DATE

???