LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (April 2007)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 11 Apr 2007 16:13:12 -0500
Reply-To:     "Beadle, ViAnn" <viann@spss.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Beadle, ViAnn" <viann@spss.com>
Subject:      Re: Counting caseworkers
Comments: To: Nora Douglas <nora.douglas@mindspring.com>
In-Reply-To:  A<15464948.1176321020840.JavaMail.root@mswamui-billy.atl.sa.earthlink.net>
Content-Type: text/plain; charset="UTF-8"

You're on the right track. Aggregate breaking on unit, region, and id, asking for the validn as the summary stat. Then in summarize, break on unit and region, asking for validn as the summary stat.

-----Original Message----- From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Nora Douglas Sent: Wednesday, April 11, 2007 2:50 PM To: SPSSX-L@LISTSERV.UGA.EDU Subject: [BULK] Counting caseworkers Importance: Low

Hello all,

This seems like it should be so simple, but the solution is eluding me. I want to count how many caseworkers are in each unit within each region. Each caseworker can have multiple cases (so each row represents a case and the caseworker ID can show up more than once under ID_WORKER) - I don't want to know how many cases they have, I want to know how many workers there are.

For the sample data set below, I want my output to tell me that there are 2 caseworkers in UNIT 1 REGION 1 (ID_WORKER 123 and 456), 2 caseworkers in UNIT 3 REGION 1 (ID_WORKER 789 and 234), four caseworkers in UNIT 1 REGION 2 (ID_WORKER 876, 987, 453, and 756) and 2 caseworkers in UNIT 2 REGION 2 (ID_WORKER 567 and 678).

I am thinking I should aggregate the file somehow, but I'm getting stuck.

Any help would be greatly appreciated.

Nora

REG UNIT ID_WORKER 1 1 123 1 1 123 1 1 123 1 1 456 1 1 456 1 3 789 1 3 789 1 3 234 1 3 234 2 1 876 2 1 987 2 1 453 2 1 756 2 2 567 2 2 567 2 2 678

Nora E. Douglas, PhD, Program Specialist Adult Protective Services Texas Department of Family and Protective Services 701 West 51st Street, Suite 500, Austin, Texas 78751 (512) 438-5324 nora.douglas@dfps.state.tx.us http://www.dfps.state.tx.us/adult_protection/


Back to: Top of message | Previous page | Main SPSSX-L page