Hi

If you add many files together, the following macro is more efficient than having many separate ADD FILES command.

* As written, next macro can handle up to 50 files at a time. A single ADD command is used.

*/////////////. DEFINE !sales (path=!TOKENS(1) /vlist2=!ENCLOSE('(',')'))

!LET !h=!HEAD(!vlist2) !LET !t=!TAIL(!vlist2) ADD FILES FILE =!path + !QUOTE(!CONCAT(!h,".sav")) !DO !z !IN (!t)/FILE=!path + !QUOTE(!CONCAT(!z,".sav"))!DOEND. SAVE OUTFILE = !path + 'Master.sav'. !ENDDEFINE. */////////////.

SET MPRINT=yes. !sales path="C:\Surveys & Forecasts, LLC\Save Files\" vlist2=(S1997 S1998 S1999 S2000 S2001 S2002 S2003).

Regards

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 Richard J. Reeves Sent: March 25, 2003 9:59 AM To: SPSSX-L@LISTSERV.UGA.EDU Subject: Performance enhancements for 11.5?

Hi Group,

I have some data sets with 600+ variables and 20,000+ records. I work with these regularly and often have to merge several (adding records). I have the sets in *.sav format and my hardware is adequate (a gig of memory and dual p4 processors).

I am wondering if anyone on the list might have some suggestions to improve performance through modifications to SPSS (other than deleting variables). Are there ways to load the sets into memory (for example)?

Rich