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!
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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.