anushakalyani Tracker https://communities.sas.com/kntur85557/tracker anushakalyani Tracker Wed, 13 May 2026 22:13:01 GMT 2026-05-13T22:13:01Z Re: Format Date to DD-MMM-YY https://communities.sas.com/t5/SAS-Programming/Format-Date-to-DD-MMM-YY/m-p/118939#M259557 <HTML><HEAD></HEAD><BODY><P>if date_9 =20DEC1984</P><P>would like convert as 20-DEC-84</P><P>You may use date_format= substr(date_9,1,2)||'-'||substr(date_9,3,3)||'-'||substr(date_9,6,4) and use format&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Format date_format DDMMYYD9<STRONG>.</STRONG></P><P></P><P></P><P><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Fri, 23 Aug 2013 09:25:03 GMT https://communities.sas.com/t5/SAS-Programming/Format-Date-to-DD-MMM-YY/m-p/118939#M259557 anushakalyani 2013-08-23T09:25:03Z Re: Proc Transpose https://communities.sas.com/t5/SAS-Procedures/Proc-Transpose/m-p/119437#M32924 <HTML><HEAD></HEAD><BODY><P>Hi Guniba,</P><P></P><P>As per your earlier question from Anca's Code where aggregation is not given which is required but you said code is working. Have you added additional to Anca's code.Could you please let us know completely</P><P></P><P>Thanks,</P><P>Anusha</P></BODY></HTML> Fri, 23 Aug 2013 06:52:06 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-Transpose/m-p/119437#M32924 anushakalyani 2013-08-23T06:52:06Z Re: a question about proc sql https://communities.sas.com/t5/SAS-Programming/a-question-about-proc-sql/m-p/97126#M20491 <HTML><HEAD></HEAD><BODY><P>Sure output returns with 0 because there are no records in x greater then 5.</P></BODY></HTML> Thu, 06 Jun 2013 13:38:32 GMT https://communities.sas.com/t5/SAS-Programming/a-question-about-proc-sql/m-p/97126#M20491 anushakalyani 2013-06-06T13:38:32Z