help! my excel file is on a flash drive known to my computer as the e:\ drive. SAS says the physical file is missing. what am i missing? thank you, folks!
gave up and bought stata
What's your question? What's the issue your having with import and how are you doing it? How is your SAS set up?
FYI CSV are text files that Excel knows how to read, they are not Excel files.
Please answer my initial questions.
What's your question? how do i import excel data to SAS studio? What's the issue your having with import
i get this error:
and how are you doing it? typing the code as per above
How is your SAS set up? I am using SAS studio.
FYI CSV are text files that Excel knows how to read, they are not Excel files. The SAS tutorial video emphasized the need to use csv format.
thank you for help
SAS Studio has some rules about files:
/pbr/biconfig/940/Lev1/SASApp/E:\000000pensionopeb\april19small.csv.
The change from / to \ tells you that SAS is running in (most likely) a Unix/Linux server mode and cannot see the flash drive attached to your computer as your machine is not the server.
You MAY be able to use an import task and navigate to that location but the code won't work.
If you could connect the thumb drive to the server, OR move a copy of the file to a location that the SERVER sees, then the code would run with the appropriate path.
thank you . . . looks like SAS Studio is worthless to me since i have no idea where the server is. Ordinarily I use LIMDEP and Eviews for my statistical analysis but they are coming up short with a regression diagnostic I need. I will investigate SAS on campus a bit more before checking out SPSS.
@eljay wrote:
thank you . . . looks like SAS Studio is worthless to me since i have no idea where the server is. Ordinarily I use LIMDEP and Eviews for my statistical analysis but they are coming up short with a regression diagnostic I need. I will investigate SAS on campus a bit more before checking out SPSS.
Are you not using University Edition? If you're a student it is an option, it's installed locally, there is no server, its on a Virtual Machine that runs on your desktop. And it's free and you can download and install at your convenience.
http://www.sas.com/en_us/software/university-edition.html
I'm going to assume SAS University Edition that you've downloaded to your machine.
1. Make sure you've set up shared folder, myfolders. See installation instructions on how that should have been done.
2. Move your CSV file to the myfolders location.
3. Reference it as '/folders/myfolders/yourfilename.csv'
If you're not using UE this doesn't apply.
SAS Studio is a type of SAS, but there are several different installation types.
One is University Edition, another links to SAS servers and called Academic On Demand, and a third allows a company to install Studio to connect to their own SAS Server. My point being that SAS Studio is not specific enough to provide information on what you're working on 🙂
Good Luck with UE.
I should mention that it has SAS/STAT but not many of the SAS/ETS (time series) procs. So depending on what you're doing it may not be suitable either.
gave up and bought stata
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!
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.