Hello HTH,   I have same issue, the date format is 9/1/2020 7:28:11 AM in excel is showing as 22159.311234 in SAS. I am using the same code to convert the excel date time to SAS suggested by you,  but unfortunately I am not getting date incorrect but time is showing correct.   The date should be 01SEP2020 however it showing as 31AUG1960. The time is showing correctly as  7:28:11 AM using the below SAS code, Could you please advise.   data want; set review.QueryDetail; format date date9.; format time timeampm.; format dt datetime21.; date=int(querydate)-21916; time=(querydate-int(querydate))*60*60*24; dt=date*24*60*60+time; run; ... View more

Hi Ramesh,   This should work. I assume you have the ODS Graphics option before your Proc Glimmix, and the default mean plots comes out of Glimmix?   Can you please show me the error message that you get? Many thanks,   Kriss Harris ... View more

If you just want to do this one time, the easiest way is to use the ODS Graphics Editor. See "Change a plot title by using the ODS Graphics Editor."   If you want to do this always, the answer is to edit the underlying template. This is described in the SAS/STAT documentation in the section titled "Modifying Graph Titles and Axis Labels." ... View more