05-28-2015 01:22 PM
I'm with problem in import Excel file in SAS University Edition no Ubuntu 14.04. I'm using the code follow;
PROC IMPORT DATAFILE="/home/joseane/Documentos/SasUniversityEdition/myfolders/sasuser.v94/cana.xls"
/** Print the results. **/
PROC PRINT DATA=WORK.MYEXCEL; RUN;
My data is attached.
The results of log windows show that,
rI esearched, read the similar discussions in this site, but not solve this problem. I'm not understand the error. Can anyone help me?
05-28-2015 01:50 PM
If you are using SAS University Edition, the reason for getting this type of error message usually is that you either 1) did not define your shared folder location correctly or 2) you did define the shared folder location, but you use the WRONG reference for the path or 3) you specify the path name wrong. For example, if I put your cana.xls file in MY shared folder location, in the ALL_EXCEL subfolder, then this is what I see as the location when I right click on the file and choose properties.
For example, here is your XLS file in MY shared folder location:
Then I right click on the folder/file and see the correct path to use (note that it does NOT use my physical file info -- the path starts /folders/myfolders)
Next I submit the code (same code as yours only with a different path in MY version of UE) and it runs successfully
Finally, I see the output.
So when you do get the data file in your shared folder location and use the right path name, the IMPORT should work. The key is using the right path.
05-28-2015 02:12 PM
I did not understand what directory was used to import data.
I believe it is the same problem of some people to use SAS University Edition.
Now, the code is working ok.
Thanks, you have a great day!