topic Question regarding dates showing as ********* in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Question-regarding-dates-showing-as/m-p/115267#M9788 <HTML><HEAD></HEAD><BODY><P>Hi Guys, </P><P></P><P>I'm super new to SAS. I've done two courses and I'm just starting to redesign some reports (in SQL/Excel) in Enterprise guide.</P><P></P><P>For one- I'm trying to get myself acquainted with what resources are out there. </P><P></P><P>I've tried googling this, but haven't anything (which is odd).</P><P></P><P>Either way, I'm having trouble with a date.</P><P></P><P>The table in the DB is coming up correctly in SAS. I can see the dates and SAS seems to recognize the field is a date (if I open the table. SAS assigns a calendar logo to the field and dates appear as "13JUL2011:00:00:00.000"</P><P>When my task is run, the dates come back in that format no worries.</P><P>As soon as I try to change to FORMAT=DATE9 I get the following output *********</P><P></P><P>It would seem that it's not happy to convert. </P><P></P><P>Where do I start to work through this?</P></BODY></HTML> Mon, 22 Apr 2013 03:31:19 GMT breelloyd 2013-04-22T03:31:19Z Question regarding dates showing as ********* https://communities.sas.com/t5/SAS-Enterprise-Guide/Question-regarding-dates-showing-as/m-p/115267#M9788 <HTML><HEAD></HEAD><BODY><P>Hi Guys, </P><P></P><P>I'm super new to SAS. I've done two courses and I'm just starting to redesign some reports (in SQL/Excel) in Enterprise guide.</P><P></P><P>For one- I'm trying to get myself acquainted with what resources are out there. </P><P></P><P>I've tried googling this, but haven't anything (which is odd).</P><P></P><P>Either way, I'm having trouble with a date.</P><P></P><P>The table in the DB is coming up correctly in SAS. I can see the dates and SAS seems to recognize the field is a date (if I open the table. SAS assigns a calendar logo to the field and dates appear as "13JUL2011:00:00:00.000"</P><P>When my task is run, the dates come back in that format no worries.</P><P>As soon as I try to change to FORMAT=DATE9 I get the following output *********</P><P></P><P>It would seem that it's not happy to convert. </P><P></P><P>Where do I start to work through this?</P></BODY></HTML> Mon, 22 Apr 2013 03:31:19 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Question-regarding-dates-showing-as/m-p/115267#M9788 breelloyd 2013-04-22T03:31:19Z Re: Question regarding dates showing as ********* https://communities.sas.com/t5/SAS-Enterprise-Guide/Question-regarding-dates-showing-as/m-p/115268#M9789 <HTML><HEAD></HEAD><BODY><P><A _jive_internal="true" class="active_link" href="https://communities.sas.com/message/150609#150609">https://communities.sas.com/message/150609#150609</A></P><P></P><P></P><P>I found a solution. </P><P></P><P>If someone else reads this with the same issue: It's because the field is a DateTime, not a Date. </P></BODY></HTML> Mon, 22 Apr 2013 04:20:35 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Question-regarding-dates-showing-as/m-p/115268#M9789 breelloyd 2013-04-22T04:20:35Z