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,255

Re: Importing Using EG SAS

What do you mean by "has issues"?

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

Data never sleeps
Regular Contributor
Posts: 198

Re: Importing Using EG SAS

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
  • 152 views
  • 0 likes
  • 3 in conversation