topic Re: hidden tables on macro in SAS Programming

hidden tables on macro

Supra8Bit — Mon, 16 Dec 2019 07:24:12 GMT

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;

Re: hidden tables on macro

Kurt_Bremser — Mon, 16 Dec 2019 07:40:25 GMT

Single-level dataset names point to library WORK.

Re: hidden tables on macro

Supra8Bit — Mon, 16 Dec 2019 08:32:02 GMT

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?

Re: hidden tables on macro

Kurt_Bremser — Mon, 16 Dec 2019 08:59:39 GMT

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.

Re: hidden tables on macro

Supra8Bit — Mon, 16 Dec 2019 11:49:31 GMT

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.