topic Make Data into equal parts in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/Make-Data-into-equal-parts/m-p/160384#M2958 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can someone help me on this query.</P><P></P><P>I've a column with nearly 1000+ rows and I wanted to make them into equal groups (if not equal, at least partially equal.). I mean it will be okay if I create a new flag column which represents 10 groups.</P><P>How can I do this using SQL.....?</P><P>Please provide some inputs at least..!</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 10 Feb 2015 04:05:12 GMT NareshAbburi 2015-02-10T04:05:12Z Make Data into equal parts https://communities.sas.com/t5/SAS-Data-Management/Make-Data-into-equal-parts/m-p/160384#M2958 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can someone help me on this query.</P><P></P><P>I've a column with nearly 1000+ rows and I wanted to make them into equal groups (if not equal, at least partially equal.). I mean it will be okay if I create a new flag column which represents 10 groups.</P><P>How can I do this using SQL.....?</P><P>Please provide some inputs at least..!</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 10 Feb 2015 04:05:12 GMT https://communities.sas.com/t5/SAS-Data-Management/Make-Data-into-equal-parts/m-p/160384#M2958 NareshAbburi 2015-02-10T04:05:12Z Re: Make Data into equal parts https://communities.sas.com/t5/SAS-Data-Management/Make-Data-into-equal-parts/m-p/160385#M2959 <HTML><HEAD></HEAD><BODY><P>Use Proc Rank. </P><P></P><P>SQL doesn't have a supported row count function that will allow you to do this. Monotonic() is unsupported so you could try that</P></BODY></HTML> Tue, 10 Feb 2015 04:46:11 GMT https://communities.sas.com/t5/SAS-Data-Management/Make-Data-into-equal-parts/m-p/160385#M2959 Reeza 2015-02-10T04:46:11Z