about converting item from character to date

SilinBorro · Posted 04-13-2015 09:53 AM

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

Madelyn_SAS · Posted 04-13-2015 10:00 AM

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 · Posted 04-13-2015 10:08 AM

Hi Silvia,

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

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 · Posted 04-13-2015 10:13 AM

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

Re: about converting item from character to date