https://communities.sas.com/t5/SAS-Programming/Convert-data-format/m-p/696313#M212659 Is your variable type actually a character or is it displayed in that format but the type is numeric?<BR /><BR />If it's a character, use Kurts solution, if its numeric just use the format statement, not the INPUT() statement. Tue, 03 Nov 2020 20:06:38 GMT Reeza 2020-11-03T20:06:38Z https://communities.sas.com/t5/SAS-Programming/Convert-data-format/m-p/696303#M212653 <P><SPAN>I'm working on a job and need to convert a character (for example: 05OCT2020) to "mmddyyyy" format&nbsp; (for example: 10/05/2020)in the table.&nbsp;Still a beginner look forward to hearing any solutions/suggestions! Thanks.</SPAN></P> Tue, 03 Nov 2020 19:27:45 GMT https://communities.sas.com/t5/SAS-Programming/Convert-data-format/m-p/696303#M212653 yichentian226 2020-11-03T19:27:45Z https://communities.sas.com/t5/SAS-Programming/Convert-data-format/m-p/696305#M212654 <PRE><CODE class=" language-sas">date = input(chardate,date9.); format date mmddyy10.;</CODE></PRE> Tue, 03 Nov 2020 19:35:00 GMT https://communities.sas.com/t5/SAS-Programming/Convert-data-format/m-p/696305#M212654 Kurt_Bremser 2020-11-03T19:35:00Z https://communities.sas.com/t5/SAS-Programming/Convert-data-format/m-p/696313#M212659 Is your variable type actually a character or is it displayed in that format but the type is numeric?<BR /><BR />If it's a character, use Kurts solution, if its numeric just use the format statement, not the INPUT() statement. Tue, 03 Nov 2020 20:06:38 GMT https://communities.sas.com/t5/SAS-Programming/Convert-data-format/m-p/696313#M212659 Reeza 2020-11-03T20:06:38Z