How to call SAS macro from another folder

pdhokriya — Fri, 04 Sep 2020 17:32:50 GMT

Hi Reader,

1. Could you please help me out to call the macro from another location.

2. This syntax I do not want to repeat, there are many numbers of dset/domain/supp_domain so is there other way to handle such senerio.

%let dset = meta_dm;
%let domain = dm1001;
%let supp_domain = suppdm;

3. Can you please share data step programming macro for below mention meta_dm.

4. Is there any other way to create meta_dm by just calling?

data meta_dm;
INFILE CARDS MISSOVER;
input variable $ label $ suppqual_flag $ remove $;
cards;
AAA NAME1 N Y
BBB NAME2 N
CCC NAME3 Y
DDD NAME4 N Y
;
RUN;

/**********************************************************************************************************/
%let dset = meta_dm;
%let domain = dm1001;
%let supp_domain = suppdm;

----------------Macro placed at other folder -------------
proc sql;
create table &domain as
select remove ,variable ,label, suppqual_flag
from &dset
where remove = "" and variable ^= "" and label ^ = "" and suppqual_flag = "N";
create table &supp_domain as
select remove ,variable ,label, suppqual_flag
from &dset
where remove = "" and variable ^= "" and label ^ = "" and suppqual_flag = "Y";
quit;

Thank you in advance.

Re: How to call SAS macro from another folder

Reeza — Fri, 04 Sep 2020 18:11:27 GMT

Not 100% sure I'm interpreting your problem correctly but it seems like you want either %INCLUDE or CALL EXECUTE.

%INCLUDE
https://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=p1s3uhhqtscz2sn1otiatbovfn1t.htm&docsetVersion=1.0&locale=en

CALL EXECUTE()
https://blogs.sas.com/content/sgf/2017/08/02/call-execute-for-sas-data-driven-programming/

topic Re: How to call SAS macro from another folder in SAS Programming

How to call SAS macro from another folder

Re: How to call SAS macro from another folder