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

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

RavenWu — Fri, 01 Jul 2016 09:03:41 GMT

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?

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

Kurt_Bremser — Fri, 01 Jul 2016 09:23:10 GMT

Most probably your server does not have a 😧 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)

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

RavenWu — Fri, 01 Jul 2016 10:00:47 GMT

You are right. The file path should be connected to the server. Thank you!

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

Kurt_Bremser — Fri, 01 Jul 2016 10:05:12 GMT

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.