topic Re: how can i import excel file in sas from second row? in SAS Programming

how can i import excel file in sas from second row?

ROHINISDAS — Thu, 17 Nov 2016 05:55:03 GMT

I want o import file from second row but it is throwing out error. Below mentioned is the statement that i have executed.Please find the attachement for error formed.

Statement Executed:

proc import datafile="C:\Documents\execrise2\Database.xls"

out= work.a

DBMS=EXCEL REPLACE;

SHEET="Gold$";

GETNAMES=NO;

DATAROW=2;

RUN;

Re: how can i import excel file in sas from second row?

SASKiwi — Thu, 17 Nov 2016 06:33:24 GMT

Your error message refers to the DELIMITER = option which is not in your posted code. Also DATAROW is not available with DBMS = EXCEL, try DBMS = XLS instead:

http://support.sas.com/documentation/cdl/en/acpcref/67382/HTML/default/viewer.htm#n0msy4hy1so0ren1acm90iijxn8j.htm

Re: how can i import excel file in sas from second row?

ROHINISDAS — Thu, 17 Nov 2016 06:59:39 GMT

Still its not working

Re: how can i import excel file in sas from second row?

SASKiwi — Thu, 17 Nov 2016 07:42:16 GMT

Post your SAS log then.

Re: how can i import excel file in sas from second row?

Kurt_Bremser — Thu, 17 Nov 2016 08:29:48 GMT

Get rid of the crappy Excel file format. Export to something sensible and text-based (CSV!!) from Excel, and read that into SAS.

Excel files only cause problems.

Why?

With Excel, you always force SAS to make guesses about column attributes and the size of the data (no of rows and columns) for you.

With a text file and a data step, you control the import process.

Run the system, don't let the system run you.

Re: how can i import excel file in sas from second row?

ROHINISDAS — Thu, 17 Nov 2016 11:18:13 GMT

i totally accept but now a days i am doing exercises based on these concept so i am eager to know the solution.

Re: how can i import excel file in sas from second row?

ballardw — Thu, 17 Nov 2016 15:14:27 GMT

Please post the log of the code you ran along with any error messages.

If there is not an error the describe exactly how it is not working. Is there no data in the result? Incomplete data? Unexpected data? Provide details of exactly what is unsatisfactory.

Note that providing the Excel file may not help as Many users here don't want to download Excel files because of virus potential, others have such things blocked by security software.