BookmarkSubscribeRSS Feed
SilinBorro
Quartz | Level 8

Hi,

I've imported an excel  file  into VA,

I've got a field  which is a timestamp  (dd/mm/yyyy:hh:mm) , but it is taken as character  by VA.

if I create a calculated item , how can I convert it from char to date?...

any idea about the instruction?

thanks a lot!

Silvia

3 REPLIES 3
Madelyn_SAS
SAS Super FREQ

You might be encountering the issue in 52060 - SAS® Visual Analytics might import date values in a Microsoft Excel spreadsheet as character.... Can you confirm that the value in Excel is truly stored as time?

Sam_SAS
SAS Employee

Hi Silvia,

I believe that the Parse() operator should do what you need.

https://support.sas.com/documentation/cdl/en/vaug/67500/HTML/default/viewer.htm#n1sxztiscf7jofn1iys4...

Parse() is categorized as a "Text (simple)" operator. Select the ANYDTDTE format to return a date value, or ANYDTDTM to return a date-time value.

Hope that helps!

Sam

MichelleHomes
Meteorite | Level 14

Could it be that you're experiencing a similar issue as before? https://communities.sas.com/thread/64936

Please check your Excel file for any characters in the column. If there are missing dates, how are they represented?

Kind Regards,

Michelle

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 3 replies
  • 7612 views
  • 1 like
  • 4 in conversation