BookmarkSubscribeRSS Feed
skipper
Calcite | Level 5

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

2 REPLIES 2
Robert_Bardos
Fluorite | Level 6
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.
Ksharp
Super User
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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 2015 views
  • 0 likes
  • 3 in conversation