You need to be more clear on what you want. I also don't understand your constraint - you don't want to use proc format?? Why?

-Joe

On Tue, Apr 28, 2009 at 9:26 AM, <aahan.sas@gmail.com> wrote:

> Hi , > Could anybody help me in solving this. > > I have one column dataset called category as below > > Category > _________ > > A > A > A > A > B > B > B > B > C > C > C > C > D > D > D > D > > Now the desired dataset should have two columns category and sort as > below > > category sort > ______________ > A 1 > A 1 > A 1 > A 1 > B 2 > B 2 > B 2 > B 2 > C 3 > C 3 > C 3 > C 3 > D 4 > D 4 > D 4 > D 4 > > The only constraint is I dont want to use any If then else of proc > format for this. Depending uon the number of categories the sort > should be assigned dynamically. This is real urgent for me. > > I really appreciate your time involved. > > Thanks in advance. >