Date: Thu, 3 Jan 2002 13:55:37 -0600
Reply-To: "Marks, Jim" <jim.marks@lodgenet.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Marks, Jim" <jim.marks@lodgenet.com>
Subject: Re: get data loop
Content-Type: text/plain; charset="iso-8859-1"
Thanks Raynald:
I took the macro for "Combine many data files" and used the Add files
command to write the file name in the macro.
I tried to use !DO !var !IN (list) but I couldn't get the macro to recognize
the list. (I used spaces and commas to separate elements in the brackets).
What is the correct way to use a list processing loop?
Jim Marks
Market Analyst
LodgeNet Entertainment Corporation
605.988.1616
IMPORTANT NOTICE: This communication (including any attached files) is
intended for the entity to which it is directed and may contain confidential
and proprietary information of LodgeNet Entertainment Corporation. The
communication is provided under the terms of the nondisclosure agreement
between LodgeNet and the intended recipient. If you are not acting solely
on behalf of the intended recipient with respect to the receipt of this
communication, you are not authorized to receive, retain, print or forward
this communication. In that event, you are directed to destroy this
communication (including any attached files), and to advise
ipmanager@lodgenet.com that you received this communication in error. If
you are authorized to receive this communication on behalf of the intended
recipient, you are obligated to treat it as confidential and proprietary
information of LodgeNet Entertainment Corporation, in accordance with the
nondisclosure agreement mentioned above.
-----Original Message-----
From: Raynald Levesque [mailto:rlevesque@videotron.ca]
Sent: Wednesday, January 02, 2002 2:15 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: get data loop
Hi
(Of course) It is possible.
For examples see
http://pages.infinit.net/rlevesqu/SampleSyntax.htm#WorkingWithManyFiles
HTH
Raynald Levesque rlevesque@videotron.ca
Visit My SPSS Pages: http://pages.infinit.net/rlevesqu/index.htm
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
Marks, Jim
Sent: Wednesday, January 02, 2002 10:59 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: get data loop
Hello list:
I need to run the following syntax for a series of files:
GET DATA /TYPE = TXT
/FILE = "C:\43325-int-1022.txt"
/DELCASE = LINE
/DELIMITERS = "|"
/ARRANGEMENT = DELIMITED
/FIRSTCASE = 2
/IMPORTCASE = ALL
/VARIABLES =
Site 7X
Date ADATE10
Time TIME11.2
Room F4.0
ICP F1.0
Index F3.0
Script A8
SerialNo A5
SoftDesc A13
FullDesc A146
.
CACHE.
EXECUTE.
SAVE OUTFILE="C:\43325-int-1022.sav"
/COMPRESSED.
The first five characters in the file name correspond to an id number. There
are 4 of them (non-consecutive). The last 4 characters correspond to a
date-- mmdd (also non-consecutive).
Is there a way to write a script that will cycle through the dates for each
id number, and through the id numbers? (I am almost ready to use the copy
and paste method 8-)
Thanks in advance
Jim Marks
Market Analyst
LodgeNet Entertainment Corporation
605.988.1616
IMPORTANT NOTICE: This communication (including any attached files) is
intended for the entity to which it is directed and may contain confidential
and proprietary information of LodgeNet Entertainment Corporation. The
communication is provided under the terms of the nondisclosure agreement
between LodgeNet and the intended recipient. If you are not acting solely
on behalf of the intended recipient with respect to the receipt of this
communication, you are not authorized to receive, retain, print or forward
this communication. In that event, you are directed to destroy this
communication (including any attached files), and to advise
ipmanager@lodgenet.com that you received this communication in error. If
you are authorized to receive this communication on behalf of the intended
recipient, you are obligated to treat it as confidential and proprietary
information of LodgeNet Entertainment Corporation, in accordance with the
nondisclosure agreement mentioned above.