Most people here won't open Office documents, as they are a security risk. Separate the problems into 3 different messages, provide text or pdf description of your problems, and make sure the data and code are provided, along with a clear description of the output desired.   Most people here don't really like being asked to "write the code" for you. We're happy to help, but you need to do some work too. ... View more

Almost anything involving dates works much better if you create a SAS date valued variable. Then sorting is actually by date order plus there are many functions and formats to manipulate the data.   The following code creates a SAS date valued variable you could use to sort the data. data have; set want; SASdate = input(case_opened_month,MONYY5.); format SASdate MONYY5.; run; proc sort data = want; by SASdate; run; Note the SASDATE variable created this way will assume a day of the month of 1 for all of the values.   If you use a different FORMAT for SASDATE you can change appearance such as display 04/01/2017, 01APR17 or 01APR2017 or even calendar quarters without adding new variables. The formats can also be used to group values for analysis or summary. ... View more

I solved the issue.Below is the code. compute case_opened_month; IF _break_='_RBREAK_' THEN CALL DEFINE('case_opened_month','style','style=[pretext="Total"]'); endcomp; ... View more