Hi all,  I would like to include more than one arguments in each parameter of  following macro. For example, in the position of ys to have more than one ys and the parameter xs to have more than one x. Please see the code below %macro multireg(ys=, yhats= ,xs=); proc robustreg data=want outest=est noprint; model &ys = &xs lnnum_lu ; output out=want p= &yhats; quit; %mend multireg; %multireg(ys=bhared_3y , yhats= bhared_3yhatm1, xs=lupe);   I want to run a code for multiple regressions e.g   %multireg(ys=bhared_3y bhared_2y bhared_1y, yhats= bhared_3yhatm1 bhared_2yhatm1 bhared_1yhatm1, xs=lupe x1 x2);   Thank you very much in advance    Regards George   ... View more

Hi all,  I would like to keep the first two observations ordered by date by group using sql in one step  proc sql; select *, ROW_NUMBER() from test_sql where ROW_NUMBER<=2 order by cusip date; quit; The above does not work Many thanks in advance Regards George ... View more

Hi all,  I would like to add a condition in my sql to drop returns appear in CRSP as 'C':    PROC SQL; create table dsf as select a.* , b.date, b.RET as RET from work.Benchmarks2 as a left join temp as b on a.cusip=b.cusip and a.Conditional_Exercise_Date<b.date and b.date<=b.date+756-count_temp; quit; /*The resulting table is:*/ Also it is stated that returns in CRSP are numeric in format but in the first row appears the letter 'C' Many thanks in advance    Regards George ... View more