Date:         Wed, 9 Nov 2005 01:50:44 -0800
Reply-To:     Sahuquillo <bangali.doctor@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sahuquillo <bangali.doctor@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Importing to SAS from MS Excel
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

Hi,

I have an excel table with 180 rows filled in, When suing Proc IMPORT
as folows:
PROC IMPORT OUT= SASUSER.IAP
            DATAFILE= "E:\MY EXCEL DOCS\IAP2005.xls"
            DBMS=EXCEL REPLACE;
     SHEET="'2003$'";
     GETNAMES=YES;
     MIXED=YES;
     SCANTEXT=YES;
     USEDATE=YES;
     SCANTIME=YES;
RUN;

I get all the empty rows in the SAS data set. How can only import rows
that have variables filled in and avoid to import empty rows ?

Thank you