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!
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.
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.