Date:         Fri, 20 Feb 2009 06:25:38 -0500
Reply-To:     Venkatesh K <venkatesh.kadiyala@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Venkatesh K <venkatesh.kadiyala@GMAIL.COM>
Subject:      infile
Content-Type: text/plain; charset=ISO-8859-1

how to read the data which is in excel,through infile stament?when i run the
below program i geting lost cards.pls help me out in this regards.

data kj;
infile 'C:\Documents and Settings\shiva1\Desktop\abc.xls';
input name $ age sex $ sal;
run;
proc print;
run;



19   data k;
20   infile 'C:\Documents and Settings\Administrator\Desktop\a.xls';
21   input name $ age sex $ amount;
22   run;

NOTE: The infile 'C:\Documents and Settings\Administrator\Desktop\a.xls' is:
      File Name=C:\Documents and Settings\Administrator\Desktop\a.xls,
      RECFM=V,LRECL=256

NOTE: LOST CARD.
name=ÐÏ � ¡± age=. sex=  amount=. _ERROR_=1 _N_=1
NOTE: 1 record was read from the infile 'C:\Documents and
Settings\Administrator\Desktop\a.xls'.
      The minimum record length was 6.
      The maximum record length was 6.
NOTE: SAS went to a new line when INPUT statement reached past the end of a
line.
NOTE: The data set WORK.K has 0 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds


23   proc print;
24   run;

NOTE: No observations in data set WORK.K.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.00 seconds
      cpu time