Code for Importing Excel Files

[deleted_user]

I typically work in a coding environment in SAS 9.2, but I have a student using SAS Enterprise Guide. Normally I use the following code to read in an excel file in 9.2 :

PROC IMPORT OUT= WORK.SET1
DATAFILE= "C:\Documents and Settings\wkuuser\Desktop\TEST_EXCEL1.xls"
DBMS=EXCEL REPLACE;
SHEET="Sheet4";
GETNAMES=YES;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;

This won't work in the coding environment for Enterprise Guide. Can someone suggest adjustments I can make to get the code to work?

Thanks.

[Doc_Duke]

EGuide has a point-n-click interface to getting the excel file in. click

file --> open --> data --> local computer
navigate to the excel file and select it, then select the sheet, and decide whether to view the sheet or to convert to a SAS dataset.

Doc Muhlbaier
Duke

[deleted_user]

You might find a code adaptation at http://support.sas.com/kb/6/976.html

[deleted_user]

Thanks. I'll see if I can use this to tweak my code.