04-24-2015 01:05 PM
If I want to use old SAS-Programs like that below in the Unversity Edition how can I conect to the excel file located elswher as in "C:\SASUniversityEdition\myfolders". This would be quit nice because I want to keep my old folder structure moving from SAS 9.3 to SASUniversty Edition.
Is there any solution?
Original SAS 9.3 code works well with SAS 9.3
PROC IMPORT OUT= WORK.Test
I am able to do this:
Moving the excel file to the "C:\SASUniversityEdition\myfolders" then import data
then importing the file like below works but it is not what I want.
PROC IMPORT DATAFILE="/folders/myfolders/Data.xls"
I changed the settings in the VMware enabeling the appropriate folder as shared Folders then trying to adopt the path in the import statement like below (even some other sturcturs tried) but it doesn't work.
PROC IMPORT DATAFILE="/folders/myfolders/DNPW/Ma15/EQPP_Gr4/Data.xls"
Many thanks in advance
then a further problem occurs I can't save the prorgamm code to the same folder (on drive D where I store the data
04-27-2015 02:56 AM
The motivation to move is that we teach more and more students coming from developing countries, who then would like to have free access to a statistic software and I would not like to give the advice to change file structures just because of the software version.
05-03-2015 06:10 PM
Here is one possible resolution in case you were still seeking one.
Download and install SAS PC Files Server from SAS. Use the profile userid and password
you created when downloading and installing SAS UE if requested. Do not install into
the SAS UE folder,follow the website instructions.
PROC IMPORT OUT=work.YourOutputDsn
*Computer Name from Control Panel\All Control Panel Items\System or
click start(i.e. Win 7) select Computer and right-click on Properties.
( if you are using Windows!).
This works for me on SAS UE (Vmplayer) Win 7 Ultimate.