topic Re: Code for Importing Excel Files in SAS Enterprise Guide

Code for Importing Excel Files

deleted_user — Mon, 27 Apr 2009 17:43:32 GMT

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.

Re: Code for Importing Excel Files

Doc_Duke — Mon, 27 Apr 2009 18:01:15 GMT

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

Re: Code for Importing Excel Files

deleted_user — Mon, 27 Apr 2009 20:15:31 GMT

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

Re: Code for Importing Excel Files

deleted_user — Mon, 27 Apr 2009 21:07:03 GMT

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