Hello,
I have a data set that contains information such as
ID DATE PAY EMP_GRADE RANK
0001 12/01/07 24.32 O-2 GEN
Each employee (ID) has observations that are daily for 2 years. The pay, grade and rank (using RETAIN) have been filled in over the entire 2 year period.
I need to pull out a specific date (Dec 31st for 2007, 2008, 2009) for each employee, so that I end with three records for each employee that include the variables ID, Pay, Grade and Rank.
ID DATE PAY EMP_GRADE RANK
0001 12/31/07 24.32 E-2 LT
0001 12/31/08 24.32 O-2 LT
0001 12/31/09 24.32 O-2 GEN
0012 12/31/07 24.32 O-2 MJR
I then have to give a frequence report for each year by the grade, counting either Enlisted (E) or Officer (O). I think I need to use a PROC FREQ, but again, not sure how to get from point A to point B. I'd really appreciate any help and insight!
Thanks in advace