Date: Wed, 30 May 2001 09:14:03 -0400
Reply-To: Mark Casazza <casazzam@ADELPHI.EDU>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Mark Casazza <casazzam@ADELPHI.EDU>
Subject: Re: SCert Essential Skills dummy test problem
Content-Type: text/plain; charset="iso-8859-1"
I downloaded the file to my download directory, and the following syntax
reads it correctly. You don't really need the file handle command, but it
makes it easier for me to read. If you want to get rid of it just replace
"FILE=EXCEL" in line two with the path to the file and discard the file
FILE HANDLE EXCEL /NAME='c:\download\scert1\readership.xls'.
GET TRANSLATE FILE=EXCEL /TYPE=XLS /RANGE A3:W3 /FIELDNAMES /MAP.
APPLY DICT FROM 'c:\download\scert1\readership dictionary.sav'.
Mark V. Casazza
Office of Research, Assessment & Planning
Levermore Hall, #307
Garden City, NY 11530
phone: (516) 877-3231
fax: (516) 877-3237
"Those who cast the votes decide nothing.
Those who count the votes decide everything."
----- Original Message -----
From: "Anne Liszt" <anneliszt@HOTMAIL.COM>
Sent: Wednesday, May 30, 2001 6:46 AM
Subject: SCert Essential Skills dummy test problem
> Hello everyone,
> Has anyone tried the SCert dummy exams yet? (SCert is apparently the SPSS
> Professional Certification program). I downloaded a zipped file containing
> the documents for the SCert Essential Skills dummy paper from:
> I can't even get past the first part! you have to open an excel file into
> SPSS (it just doesn't come into SPSS right). Does anyone know how to
> the file correctly?
> any help most appreciated
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.