topic about converting item from character to date in SAS Visual Analytics

about converting item from character to date

SilinBorro — Mon, 13 Apr 2015 13:53:03 GMT

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 — Mon, 13 Apr 2015 14:00:00 GMT

Sam_SAS — Mon, 13 Apr 2015 14:08:39 GMT

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 — Mon, 13 Apr 2015 14:13:55 GMT

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