Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

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

Accepted Solution Solved
Reply
Occasional Contributor ewv
Occasional Contributor
Posts: 15
Accepted Solution

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

[ Edited ]

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.

ScreenClip.png

 

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?

ScreenClip.png


Accepted Solutions
Solution
‎09-05-2017 12:30 PM
SAS Super FREQ
Posts: 590

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

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.

View solution in original post


All Replies
Occasional Contributor ewv
Occasional Contributor
Posts: 15

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

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.

Community Manager
Posts: 747

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

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

 

Anna

Occasional Contributor ewv
Occasional Contributor
Posts: 15

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

Posted in reply to AnnaBrown
Awesome! Thanks Anna, that's good to know. It must be an issue with my browser
Solution
‎09-05-2017 12:30 PM
SAS Super FREQ
Posts: 590

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

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.

Occasional Contributor ewv
Occasional Contributor
Posts: 15

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

Posted in reply to Madelyn_SAS

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

☑ This topic is solved.

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

Discussion stats
  • 5 replies
  • 375 views
  • 2 likes
  • 3 in conversation