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 (February 2009, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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

Back to: Top of message | Previous page | Main SAS-L page