%macro <macroname> is the beginning of the macro %mend is the end of the macro All that use in between %macro and %mend is the what you want the macro to run /* first step of the macro xls2sas*/ %macro xls2sas(folder= ,subfd=Y ,exclfd= ,startrow=); and %mend is where the macro for xls2sas ends The next step is to call the macro and this is how you call it. %xls2sas (folder= ,subfd=Y ,exclfd= ,startrow=); Did this help? ... View more

Can you provide us what is the output you are looking for just like the data what you have currently?  That way its easier, faster and efficient. ... View more

%macro xls2sas(folder= ,subfd=Y ,exclfd= ,startrow=); You need to fill in those parameters. ... View more

http://www.pharmasug.org/proceedings/2011/CC/PharmaSUG-2011-CC10.pdf ... View more

https://communities.sas.com/thread/60168 ... View more

DATA HAVE; REMAINING_MONTHS=62; OUTPUT; RUN; PROC SQL; CREATE TABLE WANT AS   SELECT     REMAINING_MONTHS,CATS((REMAINING_MONTHS / 12), "YEARS") AS YEARS FROM HAVE; QUIT; PROC PRINT; RUN; ... View more

It would be easy to get a solution if you give use the data what you have and what you want. With out ooking at the data, its not that easy to solve. ... View more

DATA WANT (DROP=LAG_DATE DIFF); SET HAVE; FORMAT LAG_DATE MMDDYY10.; IF INDEX(B,'MONTH') GE 1 THEN DO; LAG_DATE=LAG(visit_date); DIFF=INTCK('MONTH',LAG_DATE,visit_date,'C'); IF DIFF NOT IN (3) THEN FLAG='ABOVE'; END; ELSE DO; FLAG='BELOW'; END; RUN; ... View more

From the link below, I dont see any such format. Dates, Times, and Intervals : SAS Date, Time, and Datetime Values ... View more

Another way that I know, data want(keep=patid age visdate); RETAIN patid age visdate; set have; age='P'||TRIM(LEFT(ageyears))||'Y'||TRIM(LEFT(agemon))||'M'; RUN; ... View more