options minoperator mlogic; %macro test(value)/mindelimiter=','; Data _Null_; CALL SYMPUT('Vendor',2); run; %DO I=1 %TO &Vendor; /* LOOP THRU ALL Vendors */ %PUT *** LOOP &I OF &Vendor; %if &value&I in Hari RRR,John yy,Peter,Jai,Phano %then %put Value found within list.; %else %put Value not in list.; %end; %mend; %test(Hari RRR); ... View more

  Hi All,   Can anyone suggest me in executing a macro for each row in the dataset , passing arguments dynamically as given below. Suggesting a solution to me is hifhly appreciated. ---------------------------------------------------------------- Read Data1 dataset with Columns "Company" and "DSName" eg: Company DSName Comp1 DS1 comp2 DS2 ------------------------------------------------------- data _null_; set Work.Data1; length args1 $300. args2 $100.; args1 = cats("'C:\Test\",Company,".xlsx'"); args2 = cats(DSName,'_2018'); put "args1=" args1; put "args2=" args2; call execute(cats('%nrstr(%SasDS(',args1,args2,'));')); run; ------------------------------------------------------- %let Qtr=Q1; %macro SasDS(Name,Dss); libname Perm&&Qtr 'C:\Test\SasDS\&&Qtr'; PROC IMPORT OUT=Perm&&Qtr.&DSS. DATAFILE=&Name. DBMS=EXCEL REPLACE; SHEET="&&Qtr"; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; %mend SasDS; ... View more