BookmarkSubscribeRSS Feed
Iris
Calcite | Level 5

I copy and paste the path of my saved file...

ERROR: Physical file does not exist, C:\Documents and Settings\Iris\Desktop\SAS\SAS Basic

       Concepts\SASIntro\PracticeFiles\pilot.dat.

data sasuser._pilotdata1;

     infile 'C:\Documents and Settings\Iris\Desktop\SAS\SAS Basic Concepts\SASIntro\PracticeFiles\pilot.dat';

     input EmployeeID $ 1-6

             FirstName $ 7-19

             LastName $ 20-34

             JobCode $ 35-41

             Salary 42-47

             Category $ 48-50;

run;

Can't move on with my class right now because of this...Thanks a lot!

Iris.

29 REPLIES 29
art297
Opal | Level 21

Did you copy and paste the entire path .. including the filename and extension?  I would bet that one of those (filename and/or extension) are wrong.

Your syntax is correct.

art297
Opal | Level 21

I just noticed that you had posted this in the EG Forum.  SAS EG can't access data from your local drive.  The way to move it from your local drive, to the SAS server, is described at: http://support.sas.com/ondemand/learn_eg.html

Iris
Calcite | Level 5

but the data that we can upload are only sas data set, but isn't this function trying to convert a raw data set from somewhere in the computer to a sas data file?

Thanks for the help,

Iris.

art297
Opal | Level 21

You didn't read enough of the document from that link:

Working with Data Other than SAS Data Sets

If you want to work with data other than SAS data sets (such as comma delimited files or text files), you can import the files in to SAS®OnDemand for Academics: Enterprise Guide. To import non SAS data, follow these steps:

  1. Select File --> Import Data.
  2. Select Local Computer.
  3. Find and select the data file that you want to use.
Iris
Calcite | Level 5

oh, now I know how to upload the data into my library. But now it shows another error by using the same codes...

ERROR: Physical file does not exist, C:\SAS\Config\Lev1\SASApp\pilot.data.

art297
Opal | Level 21

Did you change your extension from dat to data or was that a typo?

Iris
Calcite | Level 5

and I also tried to add the files according to the C:\SAS\Config\Lev1\SASApp path, but it still didn't work.

art297
Opal | Level 21

Did you get it to work?  Are you using OnDemand for Academics: Enterprise Guide?  If you are, according to that same document, the paths where the data are located on the server all appear to begin with '\  .. not a drive name.

Iris
Calcite | Level 5

I'm using SAS Enterprise Guide 4.3. And I still can't get it to work...

art297
Opal | Level 21

I'm not familiar with EG, so I'll have to leave it to someone else to help you out.  Just out of curiosity, when you loaded the file, did it give you a directory name of where it stored the file?  It might be hidden in a log.

Iris
Calcite | Level 5

yes, I created my library already before I do this, and I store the file under my library.

and the can't locate file is the only error in the log...

Thanks for your helps though.

Iris.

art297
Opal | Level 21

FWIW, I just followed the steps in the instructions I provided earlier and EG created a SAS file from the text file and placed it in the SASUSER library.  You might want to see if that is where your file is.

Iris
Calcite | Level 5

I can upload the data without problem under my library, but the programming is not performed, I just have an additional sas file with raw data in the file. All the input commands are not performed...

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
  • 29 replies
  • 7169 views
  • 6 likes
  • 7 in conversation