BookmarkSubscribeRSS Feed
ovonel
Calcite | Level 5

Hi,

 

I have a .dat file hosted in a network drive, V.

EG is installed in my computer but connects to a server via VPN.

 

FILENAME QNS2 "V:\Data Library\ABC_X.dat";
DATA HELLO;
INFILE QNS2;
INPUT @1 ID $3.
@4 VISIT $6.
@10 DX $2;
RUN;

 

I have the error below. I am at my wits end.

 

May I know how to solve this?

 

ERROR: Physical file does not exist, V:\Data Library\ABC_X.dat.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.ABC_X may be incomplete. When this step was stopped there were 0 observations and 8 variables.
WARNING: Data set WORK,ABC_X was not replaced because this step was stopped.

4 REPLIES 4
Kurt_Bremser
Super User

Very simple. For the SAS process, the file does not exist.

- a blank in the filename causes confusion

- the network share is not mounted on the host where SAS runs

- permissions on the share/directory/file prevent the account under which the SAS process runs from access

- and many others

 

Very important here is your SAS setup

- local, with SAS used in display manager mode

- local, with Enterprise Guide

- remote, with Enterprise Guide as frontend

- remote, with SAS Studio

- if remote, which operating system on the SAS server?

ovonel
Calcite | Level 5

Hi Kurt,

 

I am not too sure.

 

I need to connect to VPN in order to see my network drive and also allow my EG (Installed on my PC) to run on the server.

 

I suppose that is remote with EG as front end.

 

Regards

 

Reeza
Super User

Then it's highly likely that EG can't see the path to the file. You can try a proc export to your local desktop and that error is easier to confirm this issue. 

 

You can use the GUI to import your data or move the file to the server. 

TomKari
Onyx | Level 15

I think your SAS session is running on a different machine than what you are running Enterprise Guide on, and your SAS server can't see a "V:" drive.

 

Tom

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
  • 4 replies
  • 1122 views
  • 4 likes
  • 4 in conversation