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

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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