Date:         Fri, 10 Feb 2012 14:01:15 -0500
Reply-To:     "Cleland, Patricia (EDU)" <Patricia.Cleland@ontario.ca>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Cleland, Patricia (EDU)" <Patricia.Cleland@ontario.ca>
Subject:      CasesToVars problem
Content-Type: multipart/alternative;

I have a data set that contains treatment data on just under 5000
agencies, located in 72 counties.  Each agency is either a Level1 or
Level2 agency. No agency is in more than one county. Each agency is a
record.

 

In addition to the agency and county identifiers, the data consists of:

-# of clients who were referred to the program; 

-#and % of clients who: attended, completed, did not attend, were still
in treatment on the date that the data was downloaded

 

 

Through AGGREGATE and MERGE, I have created a data set with 144 lines
(one per county per level, plus one for 'all counties' per level) with
the variables as above. Now I want to restructure the data so that I
have only one line for each county, plus the 'all counties' data. 

 

Here's the syntax I'm using: 

 

CASESTOVARS

  /ID=CountyNumber

  /INDEX=Level

  /GROUPBY=INDEX.

 

I expected to get the variables above with the suffix Level1 or Level2,
but for 2 variables (Num_Attended PC_Attended, that is number and % who
attended) this didn't happen. The list of Generated Variables does not
include these variables, and there is no error message as to why not.
I've tried deleting all created data files and rerunning from the raw
data set and that didn't fix the problem.  

 

Any suggestions would be appreciated. 

 

Why is it that computers always know when you're trying to get something
finished before the weekend?

 

 

 

Pat


[text/html]