BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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.
3 REPLIES 3
Doc_Duke
Rhodochrosite | Level 12
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
Not applicable
You might find a code adaptation at http://support.sas.com/kb/6/976.html
deleted_user
Not applicable
Thanks. I'll see if I can use this to tweak my code.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 833 views
  • 0 likes
  • 2 in conversation