Import Excel file into SAS

[iweinberg]

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!

[RW9 · Accepted solution]

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