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

How to convert a character date to numeric in "SAS VA" ?????

Reply
Occasional Contributor
Posts: 7

How to convert a character date to numeric in "SAS VA" ?????

 
Respected Advisor
Posts: 3,066

Re: How to convert a character date to numeric in "SAS VA" ?????

The simplest approach would be to convert the character date to a SAS (numeric) date before loading it into SAS VA. That way it will properly identified in your VA data source as a date. 

Occasional Contributor
Posts: 14

Re: How to convert a character date to numeric in "SAS VA" ?????

 

Can use the TreatAs function to convert date to numeric value( which will be stored as the number of days between January 1 1960 and the date).

Ask a Question
Discussion stats
  • 2 replies
  • 172 views
  • 1 like
  • 3 in conversation