SAS Numeric to Date in SAS VA

[sjakie45]

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?

[MichelleHomes]

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)

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

Kind Regards,

Michelle