https://communities.sas.com/t5/SAS-Programming/Date-format/m-p/812046#M320363 <P>Hi! I was wondering if anyone could possibly help me. I am asked to plot enrollment by month when enrollment variable is in mm/dd/yyyy format. How can I change it to just mm?</P><P>&nbsp;</P> Mon, 09 May 2022 00:56:09 GMT maribelchahine 2022-05-09T00:56:09Z https://communities.sas.com/t5/SAS-Programming/Date-format/m-p/812046#M320363 <P>Hi! I was wondering if anyone could possibly help me. I am asked to plot enrollment by month when enrollment variable is in mm/dd/yyyy format. How can I change it to just mm?</P><P>&nbsp;</P> Mon, 09 May 2022 00:56:09 GMT https://communities.sas.com/t5/SAS-Programming/Date-format/m-p/812046#M320363 maribelchahine 2022-05-09T00:56:09Z https://communities.sas.com/t5/SAS-Programming/Date-format/m-p/812060#M320366 You can use a month function, month(), to extract the month from that variable. Mon, 09 May 2022 03:21:58 GMT https://communities.sas.com/t5/SAS-Programming/Date-format/m-p/812060#M320366 pink_poodle 2022-05-09T03:21:58Z https://communities.sas.com/t5/SAS-Programming/Date-format/m-p/812064#M320370 <P>You could try the MONYY7. (eg Jan2022) SAS Format. That will ensure your dates are plotted correctly in date order even if they spread over multiple years.&nbsp;</P> Mon, 09 May 2022 03:55:30 GMT https://communities.sas.com/t5/SAS-Programming/Date-format/m-p/812064#M320370 SASKiwi 2022-05-09T03:55:30Z https://communities.sas.com/t5/SAS-Programming/Date-format/m-p/812078#M320383 <P>A custom date format could help, have a look at the docs of proc format and picture-type-formats. You have to be 100% sure that the source has data of a single year, only and always. If not using the format suggest by <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/13976">@SASKiwi</a> is the easiest route to solve the problem.</P> Mon, 09 May 2022 05:47:41 GMT https://communities.sas.com/t5/SAS-Programming/Date-format/m-p/812078#M320383 andreas_lds 2022-05-09T05:47:41Z