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!
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.