| 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
________________________________________________________________________________
|