hidden tables on macro

[Supra8Bit]

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;

[Kurt_Bremser]

Single-level dataset names point to library WORK.

[Supra8Bit]

Thanks for aiming. I found the Work library, but I don 't see any similar tables in it. There is (in Work) only one system table describing the SAS components and the infe. about the license. Maybe I 'm looking out there or can short names refer to other libraries?

[Kurt_Bremser · Accepted solution]

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.

[Supra8Bit]

Thanks a lot! It seems that it is really necessary to pass the course if in the future it is necessary to solve such tasks.