data set does not exist?

skipper — Sat, 12 Feb 2011 19:36:13 GMT

Whats happening, why does it say the data set does not exist when it just created it! heres what the log says...

NOTE: 181490 records were read from the infile

"C:\Users\Currys\Desktop\findata\tickdata\GBP_USD_2000\GBP_USD_Third_Quarter_2000.CSV".

The minimum record length was 57.
The maximum record length was 58.

NOTE: The data set WORK.GBP_USD_THIRD_QUARTER_2000 has 181490 observations and 6 variables.

NOTE: DATA statement used (Total process time):
real time 0.58 seconds
cpu time 0.59 seconds

296 %MakeBidAskAvg;
ERROR: File GBP_USD_Third_Quarter_2000 does not exist.

WARNING: The variable date in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.GBP_USD_THIRD_QUARTER_2000_AVG may be incomplete. When this step was
stopped there were 0 observations and 1 variables.

WARNING: Data set WORK.GBP_USD_THIRD_QUARTER_2000_AVG was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

Re: data set does not exist?

Robert_Bardos — Sun, 13 Feb 2011 08:07:59 GMT

Doesn't the log say "file ... does not exist"? You created a SAS dataset. The error message however seems to refer to an input file. Generally, it's always helpful if you post some of the relevant SAS code as well.

Re: data set does not exist?

Ksharp — Fri, 18 Feb 2011 03:34:56 GMT

I skeptic your sas temp library is TEMP.
Are you try to use work.GBP_USD_Third_Quarter_2000 for %MakeBidAskAvg

Ksharp Message was edited by: Ksharp

topic data set does not exist? in SAS Procedures

data set does not exist?

Re: data set does not exist?

Re: data set does not exist?