Date: Fri, 27 Apr 2007 00:21:19 -0700
Reply-To: Albert-jan Roskam <email@example.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Albert-jan Roskam <firstname.lastname@example.org>
Subject: Re: Trying to lock one column so only I can change it
Content-Type: text/plain; charset=iso-8859-1
Isn't it MUCH easier to use some format that can be
used by MS Access/Excel as well as SPSS (e.g. .dbf or
.xls) and use validation criteria and locking in those
--- Richard Ristow <email@example.com> wrote:
> At 03:45 PM 4/25/2007, Jennifer Jones wrote:
> >I have a data set that that multiple people will be
> making entries on.
> >While I do want others to make their entries there
> are certain columns
> >that I will be setting up in advance that I do not
> want them to
> >accidently make any changes to.
> As ViAnn Beadle said, there's no way in the Data
> Editor in base SPSS.
> What I'd do, myself, is make a separate copy of the
> dataset. I assume
> there's a unique key for the records as they are; if
> not, I'd create
> one. Then I'd let the others enter and edit as much
> as they liked. And
> finally, I'd merge (MATCH FILES) the original and
> the data. From the
> files that had been edited, I'd keep only the key
> and whatever
> variables they were allowed to edit; from the
> original file, I'd keep
> only the variables that they should NOT have edited.
> A little checking for mismatches will tell you if
> anybody altered a
> key, or added or deleted records.
> Keep the unedited file PERMANENTLY, so at least you
> can recover from
> any disaster in the data entry. And in principle
> (though not easily)
> see exactly what data was entered or changed.
> If there are "multiple people" doing entry, I'd make
> a separate dataset
> copy for each. On the merge, use ADD FILES to
> catenate the copies from
> different people first, with /IN= variables
> indicating the person who'd
> worked on that dataset, and then do the MATCH FILES.
> that's a little tricky, as it's hard to identify
> which records have
> been changed in each edited dataset. (As has
> frequently been complained
> of, there's no file-comparison tool in SPSS, at
> least not yet, except
> in the Data Entry product.) You may be able to give
> each person doing
> entry a restricted set of records to work on, if
> you've a way of
> knowing ahead of time who's assigned to add data to
> which batch of
> -Good luck to you,
Did you know that 87.166253% of all statistics claim a precision of results that is not justified by the method employed? [HELMUT RICHTER]
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around