96 data rupesh;
97 infile '?E:\s\SAS\practice\data.txt';
98 input name$ age;
99 run;
ERROR: Physical file does not exist, ?E: s\SAS\practice\data.txt.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.RUPESH may be incomplete. When this step was stopped there were 0
observations and 2 variables.
WARNING: Data set WORK.RUPESH was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.01 seconds
100 data rupesh;
101 infile '?"E:\s\SAS\practice\data.txt"';
102 input name$ age;
103 run;
ERROR: Physical file does not exist, ?"E: s\SAS\practice\data.txt".
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.RUPESH may be incomplete. When this step was stopped there were 0
observations and 2 variables.
WARNING: Data set WORK.RUPESH was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.04 seconds
data rupesh;
infile 'E:\s\SAS\practice\data.txt';
input name$ age;
run;
above one is my program,
below is the log
96 data rupesh;
97 infile '?E:\s\SAS\practice\data.txt';
98 input name$ age;
99 run;
ERROR: Physical file does not exist, ?E: s\SAS\practice\data.txt.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.RUPESH may be incomplete. When this step was stopped there were 0
observations and 2 variables.
WARNING: Data set WORK.RUPESH was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.01 seconds
100 data rupesh;
101 infile '?"E:\s\SAS\practice\data.txt"';
102 input name$ age;
103 run;
ERROR: Physical file does not exist, ?"E: s\SAS\practice\data.txt".
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.RUPESH may be incomplete. When this step was stopped there were 0
observations and 2 variables.
WARNING: Data set WORK.RUPESH was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.04 seconds
SAS is very clear about the source of the error. You refer to a file that does not exist:
?"E: s\SAS\practice\data.txt"
What is the correct spelling for the file name? Nobody can help here. You just have to name a file that actually exists. Some possibilities (because they are unusual in the spelling of a file name):
But nobody is looking at your computer except you. So find the right spelling for the file that you want to read.
file is there but it is showing error , that's why i am asking your help
do i need to change any setting?
@rupesh009 wrote:
file is there but it is showing error , that's why i am asking your help
do i need to change any setting?
You just have to TYPE THE FILENAME CORRECTLY. I guess you copy/pasted that code across something that converted part of the text to unicode. Re-type everything from scratch in SAS.
ERROR: Physical file does not exist, ?E: s\SAS\practice\data.txt.
you need to address the file path.
filename test "E:\s\SAS\practice\data.txt";
data rupesh;
infile test;
input name$ age;
run;
Are you able to associate the path to a fileref like above? Still get an error on that filename statement?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.