Help using Base SAS procedures

Importing Using EG SAS

Reply
Contributor
Posts: 59

Importing Using EG SAS

The following import worked when I used PCSAS. I was converted to Enterprise Guide(EG) a few weeks ago.

PROC IMPORT OUT= SRV_WORK.mylist1

            DATAFILE= "C:\SAS\March_2013.xlsx" 

            

            DBMS=EXCEL REPLACE;

     GETNAMES=YES;

     RANGE="Sheet1$";

     MIXED=NO;

     SCANTEXT=YES;

     USEDATE=YES;

     SCANTIME=YES;

RUN;

EG has issues with importing data and creating a work file.  Other than going with a datalines options is there a work-around.  I am using 5.1 version if that helps.

Super User
Posts: 5,428

Re: Importing Using EG SAS

Posted in reply to omega1983

What do you mean by "has issues"?

Do you get any error messages? Is your data corrupt?

Data never sleeps
Regular Contributor
Posts: 227

Re: Importing Using EG SAS

Posted in reply to omega1983

check that your filename.extension of .xlsx

is in alignment with

dbms=Excel

SAS/ACCESS(R) 9.3 Interface to PC Files: Reference

Microsoft Excel Workbook Files

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