Date:         Fri, 10 Feb 2012 14:22:24 -0500
Reply-To:     Gene Maguin <emaguin@buffalo.edu>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Gene Maguin <emaguin@buffalo.edu>
Subject:      Re: CasesToVars problem
In-Reply-To:  <6C163DDC2FC8994C99F8E837F41CCF590363CC23@CTSPITDCEMMVX28.cihs.ad.gov.on.ca>
Content-Type: multipart/alternative;

Pat,

The short answer is that I don't know but, and first of all, were those two
variables there coming out of the aggregate? If yes, and as unlikely as it
might be, could those two variables have constant values over all records?
If so, neither would have a .1/.2 extension to the variable name. Or, could
those two variables be missing for all records? I think the default is to
drop variables with missing/blank values for all records. Check the syntax
reference on this point.



Gene Maguin









From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
Cleland, Patricia (EDU)
Sent: Friday, February 10, 2012 2:01 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: CasesToVars problem



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]