I'm working with a data set in which an ID was assigned to each department who responded to our survey. We have several variables from a question matrix that we would like to analyze, particularly which department did not have women (1 variable) or minorities (another variable) working on their staff.

There are multiple responses from each department, depending on how many people they have on staff. For example, a department that had 3 males and 1 female on staff has 4 records in our dataset. A department who has 2 males and 0 females on their staff would have 2 records. The dataset, if just looking at these variables, would look like this:

CaseID Gender 1009 2 1009 1 1009 1 1009 1 1048 1 1048 1

I would like to go through each block of IDs and determine the number of departments that did NOT hire any females. What steps might I use to answer this question? (particularly if I want to write the commands in a Syntax file).

Thank you.

===================== To manage your subscription to SPSSX-L, send a message to LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD