03-03-2015 03:44 AM
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?
03-03-2015 05:57 PM
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...