topic SAS Numeric to Date in SAS VA in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-Numeric-to-Date-in-SAS-VA/m-p/189680#M1380 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Tue, 03 Mar 2015 08:44:10 GMT sjakie45 2015-03-03T08:44:10Z SAS Numeric to Date in SAS VA https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-Numeric-to-Date-in-SAS-VA/m-p/189680#M1380 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Tue, 03 Mar 2015 08:44:10 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-Numeric-to-Date-in-SAS-VA/m-p/189680#M1380 sjakie45 2015-03-03T08:44:10Z Re: SAS Numeric to Date in SAS VA https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-Numeric-to-Date-in-SAS-VA/m-p/189681#M1381 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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)</P><P><IMG alt="expression.png" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/9436_expression.png" width="450" /></P><P></P><P>Which produces the SAS date column you are after...</P><P><IMG alt="output.png" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/9437_output.png" width="450" /></P><P></P><P>Kind Regards,</P><P>Michelle</P></BODY></HTML> Tue, 03 Mar 2015 22:57:05 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-Numeric-to-Date-in-SAS-VA/m-p/189681#M1381 MichelleHomes 2015-03-03T22:57:05Z