topic Re: Extract month from a date and convert it into 3 letters in PROC SQL in SAS Programming https://communities.sas.com/t5/SAS-Programming/Extract-month-from-a-date-and-convert-it-into-3-letters-in-PROC/m-p/339908#M77602 <P>No month function, just the put.&nbsp;</P> Fri, 10 Mar 2017 07:15:03 GMT Reeza 2017-03-10T07:15:03Z Extract month from a date and convert it into 3 letters in PROC SQL https://communities.sas.com/t5/SAS-Programming/Extract-month-from-a-date-and-convert-it-into-3-letters-in-PROC/m-p/339902#M77597 <PRE>proc sql; select month(transdate) from table; quit;</PRE><P>Above gives me the month in numeric i.e 1 2 3 4 etc</P><P>I want to convert these numbers to Jan Feb Mar Apr respectively.</P><P>&nbsp;</P><P>Is there any function in proc sql allowing this?</P> Fri, 10 Mar 2017 07:01:36 GMT https://communities.sas.com/t5/SAS-Programming/Extract-month-from-a-date-and-convert-it-into-3-letters-in-PROC/m-p/339902#M77597 afiqcjohari 2017-03-10T07:01:36Z Re: Extract month from a date and convert it into 3 letters in PROC SQL https://communities.sas.com/t5/SAS-Programming/Extract-month-from-a-date-and-convert-it-into-3-letters-in-PROC/m-p/339903#M77598 <P>Look at PUT with MONNAME3 format.&nbsp;</P> Fri, 10 Mar 2017 07:07:36 GMT https://communities.sas.com/t5/SAS-Programming/Extract-month-from-a-date-and-convert-it-into-3-letters-in-PROC/m-p/339903#M77598 Reeza 2017-03-10T07:07:36Z Re: Extract month from a date and convert it into 3 letters in PROC SQL https://communities.sas.com/t5/SAS-Programming/Extract-month-from-a-date-and-convert-it-into-3-letters-in-PROC/m-p/339905#M77599 proc sql;<BR />select put(month(transdate),monname3.) as mt from table<BR />;quit; Fri, 10 Mar 2017 07:09:46 GMT https://communities.sas.com/t5/SAS-Programming/Extract-month-from-a-date-and-convert-it-into-3-letters-in-PROC/m-p/339905#M77599 afiqcjohari 2017-03-10T07:09:46Z Re: Extract month from a date and convert it into 3 letters in PROC SQL https://communities.sas.com/t5/SAS-Programming/Extract-month-from-a-date-and-convert-it-into-3-letters-in-PROC/m-p/339908#M77602 <P>No month function, just the put.&nbsp;</P> Fri, 10 Mar 2017 07:15:03 GMT https://communities.sas.com/t5/SAS-Programming/Extract-month-from-a-date-and-convert-it-into-3-letters-in-PROC/m-p/339908#M77602 Reeza 2017-03-10T07:15:03Z Re: Extract month from a date and convert it into 3 letters in PROC SQL https://communities.sas.com/t5/SAS-Programming/Extract-month-from-a-date-and-convert-it-into-3-letters-in-PROC/m-p/339910#M77604 I was about to ask... Thanks Reeza Fri, 10 Mar 2017 07:31:30 GMT https://communities.sas.com/t5/SAS-Programming/Extract-month-from-a-date-and-convert-it-into-3-letters-in-PROC/m-p/339910#M77604 afiqcjohari 2017-03-10T07:31:30Z