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

SAS Numeric to Date in SAS VA

Reply
N/A
Posts: 1

SAS Numeric to Date in SAS VA

Is it possible to convert a numeric (20150223) to a SAS Date in SAS Visual Analytics by modifying the SQL code in a column expression of a Data Query? What are the limits of the SQL Code of a column expression?

Super User
Posts: 1,228

Re: SAS Numeric to Date in SAS VA

Hi,

Yes it is possible to convert a numeric in the format YYYYMMDD to a SAS Date using SAS Visual Analytics Data Builder. Here is a screenshot of the expression that you would need to use (I am using the date column in the TEST table)

expression.png

Which produces the SAS date column you are after...

output.png

Kind Regards,

Michelle

Ask a Question
Discussion stats
  • 1 reply
  • 593 views
  • 1 like
  • 2 in conversation