hi

Thanks for your reply, here is the correct output format that i desire. the problem i am facing is to merge the group serial number and the serial number of records in the same column. further i cdnt workout with the indent option when generating with html output. can the same be achieved by monotonic() function or some other method. so that it remains dynamic and solves the purpose.

Sl. State/ UT/ Value No.

I. MAJOR STATES (Population > 20 million) 1 Andhra Pradesh 234.0 2 Assam 23.0 3 Bihar 5.0 4 Chhatisgarh 7.0 5 Gujarat 4.0 6 Haryana 3.0 7 Jharkhand 2.0 8 Karnataka 4.0 9 Kerala 6.0 10 Madhya Pradesh 8.0 11 Maharashtra 4.0 12 Orissa 2.0 13 Punjab 2.0 14 Rajasthan 4.0 15 Tamil Nadu 5.0 16 Uttar Pradesh 34.0 17 West Bengal 32.0 II. SMALLER STATES/U.T.s (Population < 20 million) 1 Arunachal Pradesh 34.0 2 Delhi 3.0 3 Goa 40 4 Himachal Pradesh 5.0 5 Jammu& Kashmir 3.0 6 Manipur 2.0 7 Meghalaya 4.0 8 Mizoram 2.0 9 Nagaland 4.0 10 Sikkim 5.0 11 Tripura 6.0 12 Uttaranchal 34.0 III. UNION TERRITORIES 1 A&N Islands 4.0 2 Chandigarh 4.0 3 D&N Haveli 5.0 4 Daman & Diu 6.0 5 Lakshadweep 3.0 6 Pondicherry 2.0

On Jul 29, 5:59 pm, j...@STANFORDALUMNI.ORG (Jack Hamilton) wrote: > The format of your report didn't make it through email unscathed, so I'm not sure exactly what you want, but you might look at the INDENT option. > > You'll still have to calculate the roman numeral yourself. If you know the categories in advance, put them in a format, which has the added advantage of alowing you to print them in an arbitrary order if you need to add another category. > > __ > Jack Hamilton > j...@alumni.stanford.org > > > > -----Original Message----- > From: Amit <adlakha.a...@GMAIL.COM> > Sent: Monday, July 28, 2008 9:34 PM > To: SA...@LISTSERV.UGA.EDU > Subject: [SAS-L] Problem in Showing Serial Number with Proc Tabulate > > Hi All, > > As this is my first interaction with the group thus warm regards to > everybody. i have been a part of this group since a while and it has > been really helpfull and knowledgable for me. > > i have a small query : > > i want to display the output report showing serial number as shown in > the table below using proc tabulate such as: The Serial Number resets > on change of group and also the group's serial number is shown in > roman. > > Sl. State/UT/ Value > No. Agency > I. MAJOR STATES (Population > 20 million) > 1 Andhra Pradesh 234.0 > 2 Assam 23.0 > 3 Bihar 5.0 > 4 Chhatisgarh 7.0 > 5 Gujarat 4.0 > 6 Haryana 3.0 > 7 Jharkhand 2.0 > 8 Karnataka 4.0 > 9 Kerala 6.0 > 10 Madhya Pradesh 8.0 > 11 Maharashtra 4.0 > 12 Orissa 2.0 > 13 Punjab 2.0 > 14 Rajasthan 4.0 > 15 Tamil Nadu 5.0 > 16 Uttar Pradesh 34.0 > 17 West Bengal 32.0 > II. SMALLER STATES/U.T.s (Population < 20 million) > 1 Arunachal Pradesh 34.0 > 2 Delhi 3.0 > 3 Goa 4.0 > 4 Himachal Pradesh 5.0 > 5 Jammu& Kashmir 3.0 > 6 Manipur 2.0 > 7 Meghalaya 4.0 > 8 Mizoram 2.0 > 9 Nagaland 4.0 > 10 Sikkim 5.0 > 11 Tripura 6.0 > 12 Uttaranchal 34.0 > III. UNION TERRITORIES > 1 A&N Islands 4.0 > 2 Chandigarh 4.0 > 3 D&N Haveli 5.0 > 4 Daman & Diu 6.0 > 5 Lakshadweep 3.0 > 6 Pondicherry 2.0 > > Thanks & Regards > Amit- Hide quoted text - > > - Show quoted text -