Suggest you look at using a DATA step to create your "count of analyst" (each gender - using IF THEN ; ) based on some input data condition. Also, derive a PERIOD_START_DATE using the INTNX function and your "date" variable along with a suitable output format such as YYMM7 or otherwise. Use PROC SORT to order your data making use of DESCENDING option in your BY statement. Lastly use PROC SUMMARY to accumulate your count/quantlty variables to generate your summarized results output. Scott Barry SBBWorks, Inc. ... View more