BookmarkSubscribeRSS Feed
Tshepi
Calcite | Level 5

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?


2 REPLIES 2
jakarman
Barite | Level 11

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/

---->-- ja karman --<-----
Tshepi
Calcite | Level 5

got it!

thank you Jaap

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 853 views
  • 1 like
  • 2 in conversation