Hello! My the first experience here. I begin to introduce SAS and look for tables specified in the macro. Looks like this - with no prefixes and no path. Where can they be ATTR? They are not in SQL Database.
%macro mEquiScoreFull;
%macro dummy; %mend dummy;
proc sql;
create table status0 as
select a.V as PaymtPat, b.*,c.*
from ATTR a
join CREDIT b
on a.C_I=b.CRED_ID and a.n=831
join RESPONSE c
on 1=1;
quit;
WORK is a dynamic library, created at the start of a SAS process and deleted when it terminates. To have datasets in there, they must be created during th "lifetime" of the current SAS session.
Since you seem to be a SAS beginner, I strongly advise that you make yourself familiar with the SAS basics before you try to work with someone else's macro code. Macro coding is a fairly advanced subject, so I advise you work through the free online Programming 1 course first.
Single-level dataset names point to library WORK.
WORK is a dynamic library, created at the start of a SAS process and deleted when it terminates. To have datasets in there, they must be created during th "lifetime" of the current SAS session.
Since you seem to be a SAS beginner, I strongly advise that you make yourself familiar with the SAS basics before you try to work with someone else's macro code. Macro coding is a fairly advanced subject, so I advise you work through the free online Programming 1 course first.
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 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.