Data query in SAS VA turns Datetime variables into aseriks when trying to convert into date variable

[ewv]

I am trying to run the query below in SAS VA. Each column within the query is the same variable from the parent dataset. This variable is defaulted to datetime when I selected it, and I'm trying to query the other one as a date variable.

However, when I preview the query, the Datetime variable is the only one that displays correctly. The same variable when converted to Date type only shows up as "*******" as shown below. Is there a reason for this or something I can do to correct it?

[ewv]

Also, for some reason the screen shots I'm including in my question aren't showing up (at least I can't see them). I can see them when I'm editing the question but they disappear when I post. Sorry that I am not able to provide the pictures for context.

[AnnaBrown]

I can see your screenshots, ewv! I can view them when both signed in and not signed in.

Anna

[ewv]

Awesome! Thanks Anna, that's good to know. It must be an issue with my browser

[Madelyn_SAS · Accepted solution]

I believe there is  more to the conversion that simply picking Date as the format. Something similar happens in SAS Information Map Studio.

http://support.sas.com/kb/31/331.html

You could try modifying the expression for the column as explained in the note.

[ewv]

Using the Datepart function appears to have worked! Thank you!