Import Excel file into SAS

iweinberg — Wed, 31 May 2017 10:34:15 GMT

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!

Re: Import Excel file into SAS

RW9 — Wed, 31 May 2017 10:42:08 GMT

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

topic Re: Import Excel file into SAS in SAS Procedures

Import Excel file into SAS

Re: Import Excel file into SAS