Hi everyone, I was wondering if anyone can help me on how to code using macro.I am very new to this. I have three survey data sets, collected at baseline, follow-up1 and follow up 2. These datasets have similar information collected. In order not to repeat the same codes in processing the data from one dataset to another, I am planning to use macro codes. I am using SAS 9.4 for windows system. %let MainPath= C:\MGP; *Exctracting datasets from Access database and Assigning Libnames; /*baseline*/ libname mgpbl "&MainPath\Data\Source Data\BL\UB2016BL.mdb"; /*FU1*/ libname mgpf1 "&MainPath\Data\Source Data\FU1\UB2016FU1.mdb"; /*FU2*/ libname mgpf2 "&MainPath\Data\Source Data\FU2\UB016FU2.mdb"; /*libname SAS data*/ libname mgp "&MainPath\Data\SASData"; I'm already stucked in the following because I am getting errors, I don't know how to proceed: %macro St (TimeIn = , mgpbl = mgpbl); data mgp.&TimeIn.StResults set &mgpbl..&TimeIn.StColl %if &TimeIn eq Baseline %then %do; %mend Hope you can shed some light. Thanks
... View more