DATA Step, Macro, Functions and more

How do I solve the error "The device is offline " by SAS Enterprise Guide

Reply
Contributor
Posts: 20

How do I solve the error "The device is offline " by SAS Enterprise Guide

I am a new user to use SAS Enterprise Guide, and it is a remote server. My code is following:

 

 

DATA garden;
  infile 'D:\The little sas book\MyRawData\Garden.dat';
  input   Name $6. Tomato 2. Zucchini 2. Peas 2. Grapes 4. Zone 2.  Type 4. Total 4. PerTom 2.4;

  Zone= 14;
  Type='home';
  Total= sum( Tomato, Zucchini, Peas, Grapes);
  PerTom = mean (Total);

Run;

 

 

The following is the log summary:

 

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      33:8   
ERROR: Device is offline.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.GARDEN may be incomplete.  When this step was stopped there were 0 observations and 9 variables.
WARNING: Data set WORK.GARDEN was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.01 seconds
      

38         
39         
40         GOPTIONS NOACCESSIBLE;
41         %LET _CLIENTTASKLABEL=;
42         %LET _CLIENTPROJECTPATH=;
43         %LET _CLIENTPROJECTNAME=;
44         %LET _SASPROGRAMFILE=;
2                                                          The SAS System                                 10:45 Friday, July 1, 2016

45         
46         ;*';*";*/;quit;run;
47         ODS _ALL_ CLOSE;
48         
49         
50         QUIT; RUN;

What does it mean with "the device is offline" and what is the problem with my codes?

 

 

 

 

 

 

Super User
Posts: 7,866

Re: How do I solve the error "The device is offline " by SAS Enterprise Guide

Most probably your server does not have a D: drive.

If you want to import a file on a remote server, you first have to copy that file to the remote server or make sure you stored the file in a shared network location that the server has access to. (and use the right drive letter or UNC)

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 20

Re: How do I solve the error "The device is offline " by SAS Enterprise Guide

Posted in reply to KurtBremser
You are right. The file path should be connected to the server. Thank you!
Super User
Posts: 7,866

Re: How do I solve the error "The device is offline " by SAS Enterprise Guide

PS I found a helpful post by doing a google search for "SAS ERROR: Device is offline.". It is usually a good idea to just search for the error message (and "SAS") with google.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 3 replies
  • 820 views
  • 0 likes
  • 2 in conversation