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 (January 2009, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Tue, 6 Jan 2009 11:05:56 -0800
Reply-To:   cherub2life@yahoo.com
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   cherub <cherub2life@YAHOO.COM>
Subject:   Data reading Error. Help needed ASAP
In-Reply-To:   <200901061838.n06I5MwM016518@malibu.cc.uga.edu>
Content-Type:   text/plain; charset=iso-8859-1

Now I have a very weird problem,I want to import a txt data whose formate likes this:zip_code phone_number date_of_birth109017741|8453684588|10201966 100246445|2125950041|05231952 I used the following code to read the data data a;infile 'C:\Documents and Settings\Desktop\data.txt' DLM='|' dsd missover truncover;format Zip_Code $30.Client_Home_Phone $40.Client_Date_Of_Birth mmddyy10.;informat Zip_Code $30.Client_Home_Phone $40.Client_Date_Of_Birth mmddyy10.;length Client_Home_Phone $40;input zip_code $Client_Home_Phone $Client_Date_Of_Birth mmddyy10.;run; Log shows no error, but he the first row of SAS data, the Client_Date_Of_Birth is always missing.Just like that  109017741 8453684588 .100246445 2125950041 05/23/1952. Could anybody help me? Thanks very much.   

Back to: Top of message | Previous page | Main SAS-L page
listserv.uga.edu
Enterprise Information Technology Services
The University of Georgia
listhelp@uga.edu