Re: Need Help: How To Combine Data From 3 Different Files?

[Alan Mead]

You need to describe what you are trying to do.

For example, I had three different files containing the same variables 
(on different samples).  I had already created SPSS SAV files.

The follow code combined them into a single database:

ADD FILES 
/FILE="G:\IIT\nsf_ethics_grant\analyses\2012-06\Ethics_Survey_STEM_participants.SAV" 

/FILE='G:\IIT\nsf_ethics_grant\analyses\2012-06\Ethics_Survey_IIT_psychstudents.SAV'
/FILE='G:\IIT\nsf_ethics_grant\analyses\2012-06\Ethics_Survey_Mich_Tech_final.SAV'
.
EXECUTE.

In the code you refer to, the square brackets [] denote optional 
commands and you would only use them if you knew what they do.  And if 
you did need those optional parts of the commands, you would NOT include 
the square braces themselves.

-Alan





On 6/26/2012 7:49 PM, zamdlr wrote:
> Thanks J'.
> I found the syntax in manual as this:
>
>   Per input file:
>               /FILE={*,'file_name'}
>               [/RENAME=(src_names=target_names)...]
>               [/IN=var_name]
>               [/SORT]
>       
>       Once per command:
>               /BY var_list[({D|A})] [var_list[({D|A}]]...
>               [/DROP=var_list]
>               [/KEEP=var_list]
>               [/FIRST=var_name]
>               [/LAST=var_name]
>               [/MAP]
>
> Frankly there are a few instruction that i don't really understand but i
> tried to do it by i. opening all 3 files ii. Open - New file -> Syntax, then
> I put this command:
>
> /FILE={*,'pdt.sav'}
>   [/RENAME=(old=new)...]
>    [/IN=var_name]
>    [/SORT]
>               
>   /FILE={*,'pst.sav'}
>   [/RENAME=(old=new)...]
>   [/IN=var_name]
>   [/SORT]
>               
>   /FILE={*,'akaun.sav'}
>   [/RENAME=(old=new)...]
>   [/IN=var_name]
>   [/SORT]
>
> iii. and press Run.
> I know this is wrong, but i don't know how to make it right. Could someone
> please give me some advise? This is 3 files has the exact variables. Thank
> you very much.
>
>
> John Darrington-4 wrote:
> > On Mon, Jun 25, 2012 at 07:02:11PM -0700, zamdlr wrote:
> >       
> > See the chapter in the manual entitled "Combining Data Files".
> >
> > J'
> >
> > --
> > PGP Public key ID: 1024D/2DE827B3
> > fingerprint = 8797 A26D 0854 2EAB 0285  A290 8A67 719C 2DE8 27B3
> > See http://keys.gnupg.net or any PGP keyserver for public key.
> >
> >
> >   
> > _______________________________________________
> > Pspp-users mailing list
> > address@hidden
> > https://lists.gnu.org/mailman/listinfo/pspp-users

--
Alan D. Mead, Ph.D.
Assistant Professor of Industrial and Organizational Psychology
College of Psychology
Illinois Institute of Technology
3101 South Dearborn, 2nd floor
Chicago IL 60616

+312.567.5933 (Campus)
+815.588.3846 (Home Office)
+312.567.3493 (Fax)

http://www.iit.edu/~mead
http://www.alanmead.org

Announcing the Journal of Computerized Adaptive Testing (JCAT), a
peer-reviewed electronic journal designed to advance the science and
practice of computerized adaptive testing: http://www.iacat.org/jcat