SPSSX Discussion

please help!

Classic

List

Threaded

9 messages Options

Nardos Ghebremedhin

please help!

I want to add files in such a way that it is done all at once. I mean is
there a way to add files located in different places at the same time
instead of adding one file after the other?

To do something like this;

get file= '
W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\jan03.sav'.

ADD FILES /FILE= *

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\feb03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\mar03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\apr03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\may03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\jun03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\jul03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\aug03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\sep03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\oct03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\nov03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\dec03.
sav'.

EXECUTE.

I AM WEARING ADDING FILES ONE BY ONE LIKE WRITEN UNDER.

get file= '
W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\jan03.sav'.

ADD FILES /FILE=*

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\feb03.
sav'.

EXECUTE.

save
outfile='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\janf
eb03.sav'.

get
file='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\janfeb0
3.sav'.

ADD FILES /FILE=*

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\mar03.
sav'.

EXECUTE.

save
outfile='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\janm
ar03.sav'.

.

.

.

Hope it is clear and understandable, and also I am using SPSS version
11.

ANY HELP IS HIGHLY APPRECIATED!

THANK YOU,

Nardos Ghebremedhin

Spousta Jan

Re: please help!

Hi Nardos,

It should be possible this way:

get file=
'W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\jan03.sav'.

ADD FILES /FILE= *
/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\feb03.
sav'
/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\mar03.
sav'
/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\apr03.
sav'
/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\may03.
sav'
/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\jun03.
sav'
/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\jul03.
sav'
/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\aug03.
sav'
/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\sep03.
sav'
/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\oct03.
sav'
/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\nov03.
sav'
/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\dec03.
sav'.
EXECUTE.

You can add up to 50 files. Hope this helps,

Jan

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Nardos Ghebremedhin
Sent: Thursday, June 15, 2006 11:50 AM
To: [hidden email]
Subject: please help!

I want to add files in such a way that it is done all at once. I mean is
there a way to add files located in different places at the same time
instead of adding one file after the other?

To do something like this;

get file= '
W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\jan03.sav'.

ADD FILES /FILE= *

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\feb03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\mar03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\apr03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\may03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\jun03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\jul03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\aug03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\sep03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\oct03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\nov03.
sav'.

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\dec03.
sav'.

EXECUTE.

I AM WEARING ADDING FILES ONE BY ONE LIKE WRITEN UNDER.

get file= '
W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\jan03.sav'.

ADD FILES /FILE=*

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\feb03.
sav'.

EXECUTE.

save
outfile='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\janf
eb03.sav'.

get
file='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\janfeb0
3.sav'.

ADD FILES /FILE=*

/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\mar03.
sav'.

EXECUTE.

save
outfile='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\janm
ar03.sav'.

.

.

.

Hope it is clear and understandable, and also I am using SPSS version
11.

ANY HELP IS HIGHLY APPRECIATED!

THANK YOU,

Nardos Ghebremedhin

Richard Ristow

Re: please help!

In reply to this post by Nardos Ghebremedhin

At 05:50 AM 6/15/2006, Nardos Ghebremedhin wrote:

>I want to add files in such a way that it is done all at once. I mean
>is
>there a way to add files located in different places at the same time
>instead of adding one file after the other?
>
>To do something like this;
>
>
>
>get file=
>'W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\jan03.sav'.
>
>ADD FILES /FILE= *
>
>/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\feb03.
>sav'.
>
>/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\mar03.
>sav'.
>
>/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\apr03.
>sav'.
>
>/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\may03.
>sav'.
>
>/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\jun03.
>sav'.
>
>/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\jul03.
>sav'.
>
>/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\aug03.
>sav'.
>
>/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\sep03.
> sav'.
>
>/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\oct03.
>sav'.
>
>/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\nov03.
>sav'.
>
>/FILE='W:\290\CPI\User_Nardos\rawdata\asmara\retail\SPSS_raw_2003\dec03.
>sav'.

It should work just like this. You can have up to 50 "/FILE"
subcommands on one ADD FILES.

However, do NOT put the periods at the end of the "/FILE" subcommands,
except for the last one. A period ends the command, and the other
"/FILE" subcommands will only give error messages. I've indented the
"/FILE" subcommands one space, as well, which is needed if you run the
command in batch mode.

Good luck!
Richard

Hector Maletta

Re: please help!

The ADD FILES command can add many files at once, but this is not possible
through the menu. Syntax:
ADD FILES /FILE 'file1.sav'/FILE 'file2.sav'/FILE 'file3.sav'/FILE
'file4.sav'/FILE 'file5.sav' ............
Instead of 'filex.sav' substitute the full pathname of your files.
Hector

-----Mensaje original-----
De: SPSSX(r) Discussion [mailto:[hidden email]] En nombre de
Richard Ristow
Enviado el: Thursday, June 15, 2006 9:06 AM
Para: [hidden email]
Asunto: Re: please help!

At 05:50 AM 6/15/2006, Nardos Ghebremedhin wrote:

rwvanderlaak

Re: please help!

In reply to this post by Richard Ristow

CONTENTS DELETED

The author has deleted this message.

Richard Ristow

Re: please help!

At 02:19 PM 6/15/2006, Roland van der Laak wrote:

>Actually the limit [for ADD FILES] is 50 files in TOTAL, so that
>includes the working file if you start with ADD FILES/FILE=* , meaning
>you can add a maximum of 49 files to the working file with the /file
>subcommands of ADD FILES.

Thank you. That's worth noting explicitly. I had written,

>>You can have up to 50 "/FILE" subcommands on one ADD FILES.

That's correct; and, strictly speaking, it is complete. But it doesn't
emphasize that the working file ("/FILE=*") is on the same footing as
external files, and counts toward the 50, and it's worth being explicit
about that.

While we're thinking about this, "/FILE=*" *is* on the same footing as
the other files, and it may be omitted. That is,

GET FILE ='c:\My_SPSS\YEAR2000.SAV'.
ADD FILES
/FILE=*
/FILE='c:\My_SPSS\YEAR2001.SAV'.

can be written, more succinctly,

ADD FILES
/FILE='c:\My_SPSS\YEAR2000.SAV'
/FILE='c:\My_SPSS\YEAR2001.SAV'.

That's easy to miss, because ADD FILES and MATCH FILES commands clicked
up from the menus, always do have "/FILE=*".

Marks, Jim

Re: please help!

In reply to this post by Nardos Ghebremedhin

The contents of the working file are the same, but the working file is
named differently depending on which way you do it.

GET FILE ='c:\My_SPSS\YEAR2000.SAV'.
ADD FILES
/FILE=*
/FILE='c:\My_SPSS\YEAR2001.SAV'.

This will give a file/ dataset called " c:\My_SPSS\YEAR2000.SAV " with
the contents of both files.

ADD FILES
/FILE='c:\My_SPSS\YEAR2000.SAV'
/FILE='c:\My_SPSS\YEAR2001.SAV'.

This will give you an unnamed file/ dataset with the contents of both
files.

The difference can matter if you are saving the working file but want to
preserve the original file.

--jim

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Richard Ristow
Sent: Thursday, June 15, 2006 5:11 PM
To: [hidden email]
Subject: Re: please help!

At 02:19 PM 6/15/2006, Roland van der Laak wrote:

>Actually the limit [for ADD FILES] is 50 files in TOTAL, so that
>includes the working file if you start with ADD FILES/FILE=* , meaning
>you can add a maximum of 49 files to the working file with the /file
>subcommands of ADD FILES.

Thank you. That's worth noting explicitly. I had written,

>>You can have up to 50 "/FILE" subcommands on one ADD FILES.

That's correct; and, strictly speaking, it is complete. But it doesn't
emphasize that the working file ("/FILE=*") is on the same footing as
external files, and counts toward the 50, and it's worth being explicit
about that.

While we're thinking about this, "/FILE=*" *is* on the same footing as
the other files, and it may be omitted. That is,

GET FILE ='c:\My_SPSS\YEAR2000.SAV'.
ADD FILES
/FILE=*
/FILE='c:\My_SPSS\YEAR2001.SAV'.

can be written, more succinctly,

ADD FILES
/FILE='c:\My_SPSS\YEAR2000.SAV'
/FILE='c:\My_SPSS\YEAR2001.SAV'.

That's easy to miss, because ADD FILES and MATCH FILES commands clicked
up from the menus, always do have "/FILE=*".

Richard Ristow

Re: please help!

Thank you! This thread is generating a lot of good thinking. As the
most recent example, at 11:40 AM 6/16/2006, Marks, Jim wrote:

If you run
GET FILE ='c:\My_SPSS\YEAR2000.SAV'.
ADD FILES
/FILE=*
/FILE='c:\My_SPSS\YEAR2001.SAV'.

or
ADD FILES
/FILE='c:\My_SPSS\YEAR2000.SAV'
/FILE='c:\My_SPSS\YEAR2001.SAV'.

>The contents of the working file are the same, but the working file is
>named differently depending on which way you do it.
>
>[The former] will give a file/ dataset called "
>c:\My_SPSS\YEAR2000.SAV " with the contents of both files.
>
>[The latter] will give you an unnamed file/ dataset with the contents
>of both files.
>
>The difference can matter if you are saving the working file but want
>to preserve the original file.

A most important point, and a strong argument for doing it the latter
way. Allan Reese (Cefas) commented about this, quite rightly, in
earlier thread "Keeping track of what you did".

Marks, Jim

Re: please help!

In reply to this post by Nardos Ghebremedhin

I learned it the hard way :~)

--jim

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Richard Ristow
Sent: Sunday, June 18, 2006 3:24 PM
To: [hidden email]
Subject: Re: please help!

Thank you! This thread is generating a lot of good thinking. As the most
recent example, at 11:40 AM 6/16/2006, Marks, Jim wrote:

If you run
GET FILE ='c:\My_SPSS\YEAR2000.SAV'.
ADD FILES
/FILE=*
/FILE='c:\My_SPSS\YEAR2001.SAV'.

or
ADD FILES
/FILE='c:\My_SPSS\YEAR2000.SAV'
/FILE='c:\My_SPSS\YEAR2001.SAV'.

A most important point, and a strong argument for doing it the latter
way. Allan Reese (Cefas) commented about this, quite rightly, in earlier
thread "Keeping track of what you did".