Dear all,
I am a very beginner of a SAS self learner. I have used libname to define the Practice library in SAS studio and tried to read a txt file saved in drive E: with following statements. However I got the error message as below:
%let path=E:\SAS\DA practice data - Original
data Practice.b_sales;
infile "&path/b_sales.txt" dlm=' ';
input purchase age gender $ income $;
run;
ERROR 180-322: Statement is not valid or it is used out of proper order
Anyone could help me explain what's wrong and how I can correct it?
Thank you very much!
Cathy
Your file separator is different .
E:\SAS\DA --> is \
"&path/b_sales.txt" --> is /
That is the reason why SAS complain it .
Xia Keshan
Your %LET statement appears to be missing a semicolon. This means that the first statement in your program is:
%let path=E:\SAS\DA practice data - Original data Practice.b_sales;
I suspect it is your INFILE statement that is getting the 180 error as it doesn't have a preceding DATA statement as it has become part of the text in your %LET statement.
Thank you very much for your help!
Your file separator is different .
E:\SAS\DA --> is \
"&path/b_sales.txt" --> is /
That is the reason why SAS complain it .
Xia Keshan
Hello Xia,
Thank you very much for your great help!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.