create &ds3. as
select one.ID, one.Gender, one.ZIP, one.State, one.age
from &ds1. as one, &ds2. as two
I want to select the observations with same ID from two files, and because I need to do this repeatedly (I have 7 data sets), so I wrote the above macro. Howeverm when I called it using the %put statement, I got an error:
ERROR 180-322: Statement is not valid or it is used out of proper order (create was underlined to indicate the error position).
Why do I get this error? Can anyone kindly give me some hint if you know about it? Thanks!
Almost always, it will be wrong to call a macro inside a %PUT statement. In this case, it is definitely wrong. Here is the beginning of your result:
%put proc sql;
create table ds3 as
If you coded this yourself, you would expect to get an error. The %PUT statement would write "proc sql" and then SAS would try to execute "create table ds3 as ...". Since there is no longer a PROC SQL statement as part of the SAS program, "create table ds3 as ..." gives you the error message.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.