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

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 1439 views
  • 0 likes
  • 3 in conversation