Help using Base SAS procedures

Import Excel file into SAS

Accepted Solution Solved
Reply
Occasional Learner
Posts: 1
Accepted Solution

Import Excel file into SAS

I am a newbie...

I am trying to import a simple Excel file into SAS (Studio). My Excel spreadsheet has only one sheet with 24 columns and 30 rows. I want the file to go into my SASUSER library (I think) so I can use it every time I log back in...

 

Here is my code:

PROC IMPORT Datafile="C:\SASUniversityEdition\myfolders\ECMO\Combined_2011_2014_Baseline.xls"
DBMS=excelcs
OUT=SASUSER REPLACE;
Sheet="Combined20112014Baseline" ;
Run;

 

I keep getting the following error:

Server Name is invalid or missing

 

What am I doing wrong?

 

Thank you in advance!


Accepted Solutions
Solution
‎05-31-2017 06:46 AM
Super User
Super User
Posts: 7,430

Re: Import Excel file into SAS

SAS UE is created on a virutal image.  You don't refer to files on that using windows drives.  Check out the user documentation for step by steps to doing all tasks UE related.

https://support.sas.com/software/products/university-edition/faq/SAS_accessdata_Excel.htm

View solution in original post


All Replies
Solution
‎05-31-2017 06:46 AM
Super User
Super User
Posts: 7,430

Re: Import Excel file into SAS

SAS UE is created on a virutal image.  You don't refer to files on that using windows drives.  Check out the user documentation for step by steps to doing all tasks UE related.

https://support.sas.com/software/products/university-edition/faq/SAS_accessdata_Excel.htm

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 153 views
  • 1 like
  • 2 in conversation