I am working with a large set of survey data. Individuals were surveyed within organizations. There are about 1,000 organizations with 20-2000 or more responses per organization. Each organization has a unique ID that is stored with each response. The date on which each respondent took the survey is included in each respondent's case in the SPSS file. Surveys were administered over a 2-4 week period at each organization, but the time periods differed between organizations.

I need to determine the earliest date that a survey response was completed for each organization. I can't think of a way to do this easily in SPSS. Any help would be greatly appreciated.

1) Go to Analyze > Compare Means > Means
2) Put "org" into "Independent List"
3) Put "date" into "Dependent List"
4) Click the button "Options"
5.a) Bring "Minimum" from the left to the right panel
5.b) If you don't want the Mean, Number of cases, and Std. Deviation, you can bring those back to the left panel
6) Click Continue
7) Click OK