I have imported a few excel files in various projects. I now have attempted to combine all my imports into one project but they are no longer running. The following error comes up , "ERROR: Physical file does not exist, /udd007/saswork/SAS_workDBE800005A4F_psasapr1l/#LN00012."
I did not write the import code. It was generatedd when I imported the files using the interface(file---Import)
Every time I run it out of its original project I get this eerror but it runs fine off its original project.
Is there anyway of fixing this quickly without having to re import all my files again into the new project?
That filename you are mentioning is form a Unix system (alikes like Linux) where:
- /udd007 is some odd naming below is that is /saswork then you get you temporary files that get deleted. That is nature of temp-files
You used the click click approach of file import. That one is:
1/ reading the file by Eguide on Windows.
2/ converting the data in a SAS-datastep code approach (text based)
3/ uploading that code with data to the Unix-server in a temp location
4/ running that sas-code from the temp location so you can get a sas-dataset
Do not be surprised that temp location is lost and you cannot rerun the upload. It will never be able to run as server-only process
It is even worse as that generated import code is using your personal settings and unc names at Windows. So may be that code in Eguide cannot be rerun by another person.
The only by-pass / solution is an approach not being dependent of those constraints with Eguide.
http://blogs.sas.com/content/sasdummy/2012/02/11/export-excel-methods/
got it!
thank you Jaap
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.