topic Assigning Numbering Sequence in SAS Data Science https://communities.sas.com/t5/SAS-Data-Science/Assigning-Numbering-Sequence/m-p/22423#M111 How do i assign a number sequence by observation?<BR /> <BR /> If there are unequal number of observations from subjects:<BR /> <BR /> Subject Observation Sequence<BR /> A XY 1<BR /> A AB 2<BR /> A ZW 3<BR /> B XY 1<BR /> C AB 1<BR /> C HG 2<BR /> <BR /> How do i create the Sequence column such that it is of running sequence by subject? Thu, 26 Nov 2009 02:06:59 GMT deleted_user 2009-11-26T02:06:59Z Assigning Numbering Sequence https://communities.sas.com/t5/SAS-Data-Science/Assigning-Numbering-Sequence/m-p/22423#M111 How do i assign a number sequence by observation?<BR /> <BR /> If there are unequal number of observations from subjects:<BR /> <BR /> Subject Observation Sequence<BR /> A XY 1<BR /> A AB 2<BR /> A ZW 3<BR /> B XY 1<BR /> C AB 1<BR /> C HG 2<BR /> <BR /> How do i create the Sequence column such that it is of running sequence by subject? Thu, 26 Nov 2009 02:06:59 GMT https://communities.sas.com/t5/SAS-Data-Science/Assigning-Numbering-Sequence/m-p/22423#M111 deleted_user 2009-11-26T02:06:59Z Re: Assigning Numbering Sequence https://communities.sas.com/t5/SAS-Data-Science/Assigning-Numbering-Sequence/m-p/22424#M112 One option is to assign a SAS numeric variable and after sorting your file with PROC SORT and using a specific BY variable list, use a DATA step to assign the numeric sequence variable. You will need to look at using a BY statement in the DATA step and using IF FIRST.<BREAK_VARIABLE> to reset your sequence variable as needed.<BR /> <BR /> Suggest you search the SAS support <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> website for DOC and supplemental technical reference and conference papers on the topic -- here is a Google advanced search argument to consider using:<BR /> <BR /> first last by group processing site:sas.com<BR /> <BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.</BREAK_VARIABLE> Thu, 26 Nov 2009 14:53:21 GMT https://communities.sas.com/t5/SAS-Data-Science/Assigning-Numbering-Sequence/m-p/22424#M112 sbb 2009-11-26T14:53:21Z