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?
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)
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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.