Hi, First time using PROC REPORT and I have not understanding the sort order. Under PROC SQL it is something like: select * from table1 order by colX asc, colY desc In PROC REPORT, I guess you use define colX / display order order=data ; define colY / display order order=data descending ; I have two questions: How do you asign an overall order to the definition? ie, I need it order by colX first and then colY How do I include display data with null values in the order column? Once you put the word order in the define line, the row no longer appears in the output. Many thanks Mark
... View more