topic Re: Could you help me to see what I did wrong that my infile function can't locate my file? Thanks! in SAS Enterprise Guide

Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

Iris — Sat, 30 Jul 2011 02:55:17 GMT

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.

Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

art297 — Sat, 30 Jul 2011 03:11:23 GMT

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.

Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

art297 — Sat, 30 Jul 2011 03:20:59 GMT

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

Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

Iris — Sat, 30 Jul 2011 03:27:17 GMT

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.

Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

art297 — Sat, 30 Jul 2011 03:35:39 GMT

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:

Select File --> Import Data.
Select Local Computer.
Find and select the data file that you want to use.

Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

Iris — Sat, 30 Jul 2011 03:50:28 GMT

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.

Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

Iris — Sat, 30 Jul 2011 03:51:46 GMT

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

Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

art297 — Sat, 30 Jul 2011 03:53:29 GMT

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

Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

Iris — Sat, 30 Jul 2011 03:55:10 GMT

typo.sorry.

Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

art297 — Sat, 30 Jul 2011 03:59:15 GMT

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.

Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

Iris — Sat, 30 Jul 2011 04:03:13 GMT

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

Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

art297 — Sat, 30 Jul 2011 04:05:49 GMT

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.

Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

Iris — Sat, 30 Jul 2011 04:11:04 GMT

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.

Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

art297 — Sat, 30 Jul 2011 04:20:11 GMT

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.

Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

Iris — Sat, 30 Jul 2011 04:25:50 GMT

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...

Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

Cynthia_sas — Mon, 01 Aug 2011 15:15:16 GMT

Hi:

When you use SAS Enterprise Guide, EG is acting as a "front-end" to SAS. There are 3 ways SAS could be installed and used:

1) EG is on your local machine and EG talks to a copy of SAS that is also installed on your machine

2) EG is on your local machine and EG talks to a copy of SAS that is installed on some other machine (could be a Windows server, could be a Unix server, could be a mainframe, could be Linux...).

3) EG is on your local machine and EG talks to a copy of SAS that is configured as part of the SAS Platform for Business Analytics (also called the BI Platform)

How you access your data, whether we are talking RAW data files (.DAT or .CSV or .TXT files) or SAS datasets, depends on which of the "flavors" of EG and SAS you are using.

EG -ALWAYS- submits code in "batch" mode. So, when you are submitting code from within EG, the "flavor" of EG you are using and where SAS actually lives (local vs on another machine) really, really makes a difference.

If you are indeed using EG in the #1 scenario, then saving or copying your files to your local drive and submitting code with a local path should have worked. The fact that you received that error message leads me to believe that you are dealing with the #2 or #3 scenario.

In the #2 or #3 scenario, your SAS session on the server has NO visibility of your local C drive. In fact, if you think about it, as an example, let's say you code a local location of c:\temp\pilot.dat (which is the name of one of the raw datas file used in the Intro self-paced elearning class), but your installation is NOT the #1 scenario -- you are working in #2 scenario and your local copy of EG is submitting code to SAS on a UNIX box. No UNIX box in the world ever has a C: drive. Unix directory names would be something like: /user/data/something/pilot.dat -- but before you could even use a directory like that, you have to move the files from your local machine to a directory on the UNIX machine, where they are accessible to SAS on the server where it lives.

I would recommend that you either talk to the SAS Administrator at your site, they can tell you which "flavor" of EG you are working with and perhaps they can tell you the best way for you to submit code or help you upload the files to a directory and build the correct INFILE statement. Otherwise, your best source of help will be to work with SAS Tech Support.

cynthia

Re: Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

mayankgoel01 — Mon, 04 Feb 2013 20:17:42 GMT

Hi Cynthia,

Your response above is very informative. I too am facing the same issue with EG. I am now certain that EG does not access my local drive to look for pilot.dat and does not recognize SASintro library, hence gives an error. (ERROR: Library SASINTRO does not exist.)

I do not have access to any onsite SAS admin who could help me resolve this. Raw data files that I specify in my programs came with SAS training material so I was hoping these files also already exist on server and would not require an import.

I have completed the training but have not been able to try any of the codes due to such errors. It would be great if you could help.

Mayank

Re: Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

ChrisHemedinger — Mon, 04 Feb 2013 20:22:17 GMT

Mayank,

If you have the file local on your PC, you can use the Copy Files task to upload it to your SAS server.

Here is information about the Copy Files task and how you can get it:

There and back again: copying files in SAS Enterprise Guide - The SAS Dummy

Chris

Re: Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

mayankgoel01 — Mon, 04 Feb 2013 20:43:07 GMT

Thanks Chris. Im sorry but I could not locate Copy Files screen in EG.

Re: Could you help me to see what I did wrong that my infile function can't locate my file? Thanks!

ChrisHemedinger — Mon, 04 Feb 2013 20:52:04 GMT

You have to download the task from a link on the blog post. It's not built in to EG - it was developed and released later as a productivity tool.