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 (October 2002)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 7 Oct 2002 11:15:20 -0600
Reply-To:     Geoff Matthews <>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Geoff Matthews <>
Subject:      Changing letter case and merging files
Content-Type: text/plain; charset="US-ASCII"

I have a few questions:

1) I am working with two data files that have matching variables. One of the files has the variables all in caps (string variable, of course), I'd like to change this to all lower-case. Any suggestions?

2) I also want to merge these two files, and here's where a real problem arises. I do not have a unique identifier for each case (students, in this instance). So, I want to match students on first name, last name and school. All attempts thus far have been hung up on the second case, with the claim that the file is not in non-descending order. I've repeatedly tried to change this. Case sensitivity may be part of the problem (thus, question #1), but in case it isn't, any other suggestions?


Geoff Matthews Data Analyst Waterford Institute 801-576-4924 ICQ #166775292

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