I have created sample dataset and the required format output . I want one .txt file which should have all distributions horizontally . Is there a way to do that data test; input date1 date2 date3; cards; 20201012 20201013 20201014 20201012 20201013 20201014 20201012 20201013 20201014 20171012 20171013 20171014 20201012 20201013 20201014 20171012 20171013 20171014 20171012 20171013 20171014 20171012 20171013 20171014 20171012 20171013 20171014 ; run; %macro dist(ind); proc sql; create table count_&ind. as select &ind., count (*) as COUNT from test group by &ind. order by 2 desc ; quit; %mend; %dist(date1);%dist(date2);%dist(date3);
... View more
