07-01-2016 05:03 AM
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?
07-01-2016 05:23 AM
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)
07-01-2016 06:05 AM
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.