Desktop productivity for business analysts and programmers

Unable to import xls file to sas dataset

Reply
Occasional Contributor
Posts: 14

Unable to import xls file to sas dataset

Dear Friends

I am trying to use several methods to import an xls file using sas code in SAS Enterprise Guide

And each yields errors .

The source file is located on a local file system.

I can import the file successfully using the SAS enterprise guide import task..

Your help is appreciated.

First Method : Proc Import

proc import

     datafile= 'u:\testfile.xls'

     dbms=excel

   

     out=work.out

     replace;

run;

The error I get:

ERROR: Unable to open file u:\testfile.xls. It does not  exist or it is already opened exclusively by another user, or you need

       permission to view its data.

Method 2 Using LibName Statement

libname myxls  "u:\TestFile.xls";

The error I get

ERROR: Connect: Class not registered

ERROR: Error in the LIBNAME statement.

Esteemed Advisor
Posts: 5,198

Re: Unable to import xls file to sas dataset

As you can see from many other questions in htis forum, it's a common misunderstanding that your local file system is available for your SAS code. It's available in the import tasks. SAS code is executed on your SAS Workspace server, so the given file path needs to be available from there.

Data never sleeps
Occasional Contributor
Posts: 14

Re: Unable to import xls file to sas dataset

Thank you very much - i didn't know that.

Rafael

Ask a Question
Discussion stats
  • 2 replies
  • 496 views
  • 3 likes
  • 2 in conversation