|
Read the age as CHAR (ageCH $) rather than numeric.
Then use the logic:
if index(ageCH,'*') ne 0 then age=.;
else age=ageCH + 0;
Regards
IRa
On Mon, 31 Mar 2003 20:13:09 -0800, SASler <soundblast100@YAHOO.COM> wrote:
>wealth age region
>37 50 M
>24 88 U
>14 64 A
>13 * U
>13 66 U
>11.7 72 E
>
>i need to copy this text file into sas. when i tried to use the infile
>statement, INFILE "C:\test\copy.txt" FIRSTOBS=2;
>i am getting an error "invalid data for age".
>how do i copy this file? Thanks all.
| 
