https://communities.sas.com/t5/SAS-Enterprise-Guide/generating-id-number/m-p/946#M263 Hi, <BR /> How do I do to automatically generate a unique id number, with condition, to my data set???<BR /> <BR /> Thanks! Mon, 03 Jul 2006 14:18:53 GMT deleted_user 2006-07-03T14:18:53Z https://communities.sas.com/t5/SAS-Enterprise-Guide/generating-id-number/m-p/946#M263 Hi, <BR /> How do I do to automatically generate a unique id number, with condition, to my data set???<BR /> <BR /> Thanks! Mon, 03 Jul 2006 14:18:53 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/generating-id-number/m-p/946#M263 deleted_user 2006-07-03T14:18:53Z https://communities.sas.com/t5/SAS-Enterprise-Guide/generating-id-number/m-p/947#M264 Hello.<BR /> <BR /> You could use the MONOTONIC() function in a query. This undocumented SQL feature allows you to add a sequential number (1 on first row, 2 on second, 3 and so on). If you have conditions in a WHERE statement, the numered rows are only the selected ones.<BR /> <BR /> I hope it solves your problem. Tue, 04 Jul 2006 08:22:01 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/generating-id-number/m-p/947#M264 Olivier 2006-07-04T08:22:01Z