topic Re: Data query in SAS VA turns Datetime variables into aseriks when trying to convert into date vari in SAS Visual Analytics

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

ewv — Tue, 05 Sep 2017 15:03:34 GMT

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?

Re: Data query in SAS VA turns Datetime variables into aseriks when trying to convert into date vari

ewv — Tue, 05 Sep 2017 15:11:21 GMT

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.

Re: Data query in SAS VA turns Datetime variables into aseriks when trying to convert into date vari

AnnaBrown — Tue, 05 Sep 2017 15:14:51 GMT

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

Anna

Re: Data query in SAS VA turns Datetime variables into aseriks when trying to convert into date vari

ewv — Tue, 05 Sep 2017 15:47:45 GMT

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

Re: Data query in SAS VA turns Datetime variables into aseriks when trying to convert into date vari

Madelyn_SAS — Tue, 05 Sep 2017 16:10:40 GMT

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.

Re: Data query in SAS VA turns Datetime variables into aseriks when trying to convert into date vari

ewv — Tue, 05 Sep 2017 16:30:35 GMT

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