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

How 2 Convert imported FB dates into SAS VA datetime format

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

How 2 Convert imported FB dates into SAS VA datetime format

Hi Community,

 

This is a simple one but please help anyway

 

- I have imported FB data into SAS Visual Analytics - and now the publisheddatetimestr variable in the imported datatable is an CATEGORY variable of the text form:

 

"March 7, 2016 9:32:53 PM GMT"

 

I expect that by creating the right formula in "New Calculated Item" builder in VA I can convert this textstring into a date (or datetime) variable that I can do date hierarchies on - but I have not managed yet to do the needed PARSING.

 

Can anyone help me on this simple one, please?

 

 

 


Accepted Solutions
Solution
‎03-07-2016 07:16 PM
Occasional Contributor
Posts: 13

Re: How 2 Convert imported FB dates into SAS VA datetime format

Sorry for bothering again - I came up with an workable solution in 2 steps - but any better one step solution is most welcome.

View solution in original post


All Replies
Solution
‎03-07-2016 07:16 PM
Occasional Contributor
Posts: 13

Re: How 2 Convert imported FB dates into SAS VA datetime format

Sorry for bothering again - I came up with an workable solution in 2 steps - but any better one step solution is most welcome.

Trusted Advisor
Posts: 1,289

Re: How 2 Convert imported FB dates into SAS VA datetime format

Well done in working out the solution and thanks for sharing it too! (I was in the process of posting a similar approach.) Smiley Happy

 

Kind Regards,

Michelle

☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 620 views
  • 1 like
  • 2 in conversation