LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 2003)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 24 Jul 2003 10:27:34 -0400
Reply-To:   "Snider-Lotz, Tom" <TSnider-Lotz@qwiz.com>
Sender:   "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:   "Snider-Lotz, Tom" <TSnider-Lotz@qwiz.com>
Subject:   Re: How to deal with "junk" lines in raw data file
Content-Type:   text/plain; charset="iso-8859-1"

This is the best suggestion yet -- it's simple, and it works. Thanks, Frank.

I noticed that SKIP = {n} is shown in the PDF file as part of the DATA LIST syntax, but it's never explained.

Thanks to everybody who responded on this, especially those who responded several times. Even though I'm back to my original DATA LIST approach, I did try the GET DATA and INPUT PROGRAM approaches -- my first time for both of these -- and I learned quite a bit. It's the best way to learn.

-- Tom

-----Original Message----- From: Frank Milthorpe [mailto:Frank.Milthorpe@TRANSPORT.NSW.GOV.AU] Sent: Thursday, July 24, 2003 12:34 AM To: SPSSX-L@LISTSERV.UGA.EDU Subject: Re: How to deal with "junk" lines in raw data file

Here is an alternative approach extending the suggestion from Richard Ristow <wrristow@mindspring.com>.

If you use the DATA LIST command, you can say how lines of data are skipped! See example below skipping 5 lines.

DATA LIST SKIP = 5 LIST (",") / var1, var2 .

BEGIN DATA A /* The first 5 records are skipped B C D E 1,11 2,22 3,33 4,44, 5,55 END DATA.

LIST.

Regards

Frank Milthorpe

-------------------------------------------- Frank Milthorpe Transport Modelling Manager Transport Data Centre Department of Infrastructure, Planning and Natural Resources GPO Box 1620, Sydney NSW 2001 Level 17, 227 Elizabeth St, Sydney Tel: +61 2 9268 2937 Fax: +61 2 9268 2853 Email: frank.milthorpe@transport.nsw.gov.au

________________________________________________________________________________

This message (including any attachments) is intended solely for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of the Ministry of Transport. The whole or parts of this e-mail may be subject to copyright of the Ministry or third parties. You should only re-transmit, distribute or use the material for commercial purposes if you are authorised to do so.

Visit us at:

www.transport.nsw.gov.au or www.131500.com.au

________________________________________________________________________________


Back to: Top of message | Previous page | Main SPSSX-L page