Desktop productivity for business analysts and programmers

Question regarding dates showing as *********

Accepted Solution Solved
Reply
Contributor
Posts: 20
Accepted Solution

Question regarding dates showing as *********

Hi Guys,

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.

For one- I'm trying to get myself acquainted with what resources are out there.

I've tried googling this, but haven't anything (which is odd).

Either way, I'm having trouble with a date.

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"

When my task is run, the dates come back in that format no worries.

As soon as I try to change to FORMAT=DATE9 I get the following output *********

It would seem that it's not happy to convert.

Where do I start to work through this?


Accepted Solutions
Solution
‎04-22-2013 12:20 AM
Contributor
Posts: 20

Re: Question regarding dates showing as *********

https://communities.sas.com/message/150609#150609

I found a solution.

If someone else reads this with the same issue: It's because the field is a DateTime, not a Date.

View solution in original post


All Replies
Solution
‎04-22-2013 12:20 AM
Contributor
Posts: 20

Re: Question regarding dates showing as *********

https://communities.sas.com/message/150609#150609

I found a solution.

If someone else reads this with the same issue: It's because the field is a DateTime, not a Date.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 152 views
  • 0 likes
  • 1 in conversation