Date:         Tue, 7 Jan 1997 08:03:10 +0000
Reply-To:     Niels Ejner Andersen <nea@TDK.DK>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Niels Ejner Andersen <nea@TDK.DK>
Subject:      REF: data set problem

Tim,
 
 
try using comma10.3
 
 
Niels Ejner Andersen
Tele Danmark
 
 
 
 
 
 
>>Hi SAS users,
>>
>>      I use 'comma' format to read a variable which is at the
>>      end of a record. The data set is saved as a space delimited
>>      text file from Excel. This file is like:
>>.........+.........+.........+.........+
>>Mary   646 Green St.   50.01    556.44
>>John   8766 Gray Av.   (56.3)    75.98
>>Jack   12 Marion Rd.    6.77    (45.62)
>>
>>...
>>*********
>>If I use the following format, (45.62) can not be read in, that is,
>>the value is missing.
>>
>>@1  name    $4
>>@8  address $13
>>@21 num1    comma9.2
>>@30 num2    comma9.2;
>>
>>*********
>>If I use comma10.2 instead, both 556.44 and 75.98 cannot be read in.
>>
>>
>>Any idea?
>>
>>Thanks!
>>
>>Tim