topic export Month and Year SAS date in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/export-Month-and-Year-SAS-date/m-p/126873#M34801 <HTML><HEAD></HEAD><BODY><P>I have a SAS date1 in form YYMMP7. and another date2 in the form of MMDDYYP10.&nbsp; when I export the file to Excel I also get the day in the form of 2011/01/12 .. I tried parcing it, but there must be an easier way to just get Month and Year (eg. Jun2009 or 06.200) to export..&nbsp; Thanks</P><P><BR /> </P></BODY></HTML> Wed, 01 May 2013 18:42:45 GMT podarum 2013-05-01T18:42:45Z export Month and Year SAS date https://communities.sas.com/t5/SAS-Procedures/export-Month-and-Year-SAS-date/m-p/126873#M34801 <HTML><HEAD></HEAD><BODY><P>I have a SAS date1 in form YYMMP7. and another date2 in the form of MMDDYYP10.&nbsp; when I export the file to Excel I also get the day in the form of 2011/01/12 .. I tried parcing it, but there must be an easier way to just get Month and Year (eg. Jun2009 or 06.200) to export..&nbsp; Thanks</P><P><BR /> </P></BODY></HTML> Wed, 01 May 2013 18:42:45 GMT https://communities.sas.com/t5/SAS-Procedures/export-Month-and-Year-SAS-date/m-p/126873#M34801 podarum 2013-05-01T18:42:45Z Re: export Month and Year SAS date https://communities.sas.com/t5/SAS-Procedures/export-Month-and-Year-SAS-date/m-p/126874#M34802 <HTML><HEAD></HEAD><BODY><P>If you don't mind rewriting the dataset, you could put(date1,yymmp7.)&nbsp; </P></BODY></HTML> Wed, 01 May 2013 20:26:29 GMT https://communities.sas.com/t5/SAS-Procedures/export-Month-and-Year-SAS-date/m-p/126874#M34802 DBailey 2013-05-01T20:26:29Z