Sorry, what should be the output from that data you have given, should it be two records the 456 ones?  If so proc sort should handle that fine.  Or do you mean where a value appears in any column? ... View more

Hi, Have a look at the INTCK function as this does all the different intervals - QTR, YEAR, MONTHS etc. Just to note, you would need to check if yearpart different from yearpart other date first. ... View more

Hi, There was a post today, almost the same thing: https://communities.sas.com/thread/57555 Check that out.  You would want to go the route of generating the code as you have so many variables, maybe using a datastep and call execute, or macro code. ... View more

Please post some data and required output. ... View more

I would suspect then as you don't have getnames=yes; option, that it has been read in using default names for the columns, e.g. col1 col2 etc. ... View more

Hi, Try: data have;   attrib p format=$20. m1-m4 format=best.;   infile datalines delimiter=',';   input p $ m1-m4; datalines; 1,8,1,., 9 2,.,.,3,15 3,4,5,.,12 4,1,.,.,10 ; quit; proc sql;   create table OUTPUT1   (     MONTH1INTERSECTMONTH2 num,     MONTH2INTERSECTMONTH3 num,     MONTH3INTERSECTMONTH4 num   );   create table OUTPUT2   (     MONTH2INTERSECTMONTH1 num,     MONTH3INTERSECTMONTH21 num,     MONTH4INTERSECTMONTH321 num   );   insert into OUTPUT1   set MONTH1INTERSECTMONTH2=(select count(P) from WORK.HAVE where M1 is not null and M2 is not null),       MONTH2INTERSECTMONTH3=(select count(P) from WORK.HAVE where M2 is not null and M3 is not null),       MONTH3INTERSECTMONTH4=(select count(P) from WORK.HAVE where M3 is not null and M4 is not null);   insert into OUTPUT2   set MONTH2INTERSECTMONTH1=(select count(P) from WORK.HAVE where M2 is not null and M1 is not null),       MONTH3INTERSECTMONTH21=(select count(P) from WORK.HAVE where M3 is not null and (M2 is not null or M1 is not null)),       MONTH4INTERSECTMONTH321=(select count(P) from WORK.HAVE where M4 is not null and (M3 is not null or M2 is not null or M1 is not null)); quit; ... View more

In addition to the issue, some suggestions: The below uses call execute to directly generate the required code. data _null_;   array models{2} $200. ("vret_msa mktrf100","vret_msa mktrf100 ind_ret");   do i=1 to 2;     call execute('proc sql;                     create table WORK.TMP as                     select  *                     from    A.A14                     where   PERIOD='||put(i,1.)||';                   quit;                   ods _all_ close;                   ods output parameterestimates=pe'||put(i,1.)||strip(models{i})';                   proc reg data=work.tmp;                     by permno;                     model ereturn_i='||strip(models{i})||';                   run;                   quit;                   ods rtf file="s:\temp\rob\period_'||put(i,1.)||'_model_'||strip(models{i})||' style=journal;                   proc means data=pe'||put(i,1.)||strip(models{i})';                     var estimate;                     class variable;                   run;                   ods rtf close;');   end; run; You could also use call execute to generate the code to call you macro like: %macro twostep (period=,model=);   ... %mend twostep; data _null_;   array models{2} $200. ("vret_msa mktrf100","vret_msa mktrf100 ind_ret");   do i=1 to 2;     call execute('%twostep (period='||put(i,1.)||',model='||strip(models{i})');');   end; run; ... View more