data want; set test; team1 = scan(match, 1); team2 = scan(match, 3); call sortc(team1, team2); run; proc freq data=want; table team1*team2 / list; run; @krishnaalla wrote: i want to group the values : example:  AUS Vs IND  having 10 values IND Vs AUS  having 15 values     treat as a similar value and group it as one value.    in need IND Vs AUS count as 25 values   ... View more

Nope, sorry, msoffice2k_x is merely a slighty more feature rich version of msoffice2k: http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/   You cannot get multiple sheets using this tagset because - quite simply - HTML output does not have the concept of pages or sheets.  You are using HTML thus there is no option to do this.    You can do this by creating XML using excelxp tagsets - I do not understand your aversion to moving to this?   As for inserting sheets using DDE two things: Firstly your file is HTML not an Excel file.  Excel can read and interpret the HTML and show you the data in Excel, but you would still need to save that conversion to Excel to get the Excel functionality you require - HTML does not have this. Secondly DDE is ancient, well over 15 years old now and discontinued by MS, it doesn't work in several scenarios.  I would really advise you look at modern technique sucj as output via Excelxp tagsets, libname Excel, or CSV output and use VBA in Excel to create the output you need. ... View more