topic Re: SAS OnDemand: unable to read file in SAS Programming

SAS OnDemand: unable to read file

darwise — Mon, 14 Feb 2022 20:28:36 GMT

Hello - I am trying to run a contaminant load estimation model in the SAS Studio OnDemand environment that is configured to read in an rdb file with daily streamflow values. This program works successfully on a locally installed version of SAS, but is unable to find the rdb file when I try to run it in the SAS OnDemand environment. I've confirmed that the directory paths in the program are consistent with the paths in my OnDemand workspace. I suspect that this is probably not enough information for someone to help me out, but at least maybe it's a starting point.

Thanks.

Re: SAS OnDemand: unable to read file

Reeza — Mon, 14 Feb 2022 20:37:06 GMT

By this:

I've confirmed that the directory paths in the program are consistent with the paths in my OnDemand workspace.

You mean you've uploaded the RDB files to the server space and you've verified the files exist in the workspace?

@darwise wrote:

Hello - I am trying to run a contaminant load estimation model in the SAS Studio OnDemand environment that is configured to read in an rdb file with daily streamflow values. This program works successfully on a locally installed version of SAS, but is unable to find the rdb file when I try to run it in the SAS OnDemand environment. I've confirmed that the directory paths in the program are consistent with the paths in my OnDemand workspace. I suspect that this is probably not enough information for someone to help me out, but at least maybe it's a starting point.

Thanks.

Re: SAS OnDemand: unable to read file

ballardw — Mon, 14 Feb 2022 23:36:30 GMT

What does your LOG show when you run the code on SAS On Demand for what you use to read the file?

Re: SAS OnDemand: unable to read file

darwise — Tue, 15 Feb 2022 21:18:59 GMT

Yes - I've confirmed that the RDB file exists in my workspace.

Re: SAS OnDemand: unable to read file

darwise — Tue, 15 Feb 2022 21:21:34 GMT

ERROR: Data for flow station 11012500 does not exist - station not processed

ERROR: The MACRO windowing environment cannot be initialized due to a XU supervisor failure.

ERROR: The macro PUT_COMMENT will stop executing.

Re: SAS OnDemand: unable to read file

Reeza — Tue, 15 Feb 2022 21:29:42 GMT

From that error it appears that there's a problem with the macro/code - it's designed to handle the case when a station data doesn't exist for some reason by telling you there's an error:

This is not a SAS error, this is code from your program:
ERROR: Data for flow station 11012500 does not exist - station not processed

Re: SAS OnDemand: unable to read file

darwise — Wed, 16 Feb 2022 15:13:04 GMT

Thanks for your feedback. This program (and all associated macros) ran successfully on a local version of SAS, but not in the SAS OnDemand environment. Therefore, I concluded that the problem was due to trying to run it using OnDemand.

Re: SAS OnDemand: unable to read file

Reeza — Wed, 16 Feb 2022 15:43:12 GMT

Is the source data the same locally as in On Demand?

Re: SAS OnDemand: unable to read file

darwise — Wed, 16 Feb 2022 16:59:20 GMT

Yes - the programs, the macros, and the input files are the exact ones used on the locally installed SAS.

Re: SAS OnDemand: unable to read file

Reeza — Wed, 16 Feb 2022 17:08:48 GMT

For 100% check - you're not using PROC IMPORT anywhere in your code correct?
I'm assuming you've checked the data and that Station data is present.

Re: SAS OnDemand: unable to read file

darwise — Wed, 16 Feb 2022 19:42:03 GMT

One of the macros that is used has the code below (with PROC IMPORT). Is that causing a problem in the OnDemand version of SAS?

/* Macro loads the model specifications and associated key files into sas. */

%macro set_model_specs_files ;

options nomprint nomacrogen nosource ;
/* Point to an external file to be created */
filename tempout "&results_home.\tempout.txt" ;
/* Redirect the output to a file */
proc printto log=tempout new ;
run ;
proc import datafile = "&model_specs_file" out = model_specs_file dbms = tab replace ;
run ;
data model_specs_file ;
length station_id $ &station_id_length ;
format station_id $&station_id_length.. ;
informat station_id $&station_id_length.. ;
set model_specs_file ;
run ;
proc import datafile = "&model_specs_key_file" out = model_specs_key_file dbms = tab replace ;
run ;
/* Redirect the output back to the output window */
%if %upcase(&if_output_log) = YES %then %do ;
proc printto log = filelog ;
run ;
%end ;
%else %do ;
proc printto ;
run ;
%end ;
%let rc = %sysfunc(fdelete(tempout)) ;
options &sas_options ;

%mend set_model_specs_files ;

Re: SAS OnDemand: unable to read file

Reeza — Wed, 16 Feb 2022 20:01:10 GMT

Run a proc contents on the data set of each data set imported via proc contents in each system and verify they are the exact same - length/formats/types.