SAS to VBA module

[ping99]

Hi all,

I have the codes in SAS below in the module or function called Macro_test.sas

'-----------------------------------------------------------
'Parameter: Basetest=test , Scoring=test10 , month=9

%macro Macro_test(Basetest= ,Scoring= , MONTH= );

libname mydata &Basetest;
libname mydata2 &Scoring;

proc sql;

create table New&MONTH as
select distinct scoringNo
from mydata2.scoringall_&MONTH;
quit;

run;
'----------------------------------------------------

Can somebody helps to translate above SAS codes in VBA code to get a similar result ?

TIA