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?
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.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Creating Beautiful Reports
SAS Visual Analytics Learning Center
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.
I can see your screenshots, ewv! I can view them when both signed in and not signed in.
Anna
Join us for SAS Community Trivia
SAS Bowl XXIX, The SAS Hackathon
Wednesday, March 8, 2023, at 10 AM ET | #SASBowl
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.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Creating Beautiful Reports
SAS Visual Analytics Learning Center
Using the Datepart function appears to have worked! Thank you!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.