https://communities.sas.com/t5/Statistical-Procedures/SAS-Add-in/m-p/598214#M29123 Try date9. Mon, 21 Oct 2019 18:52:58 GMT tomrvincent 2019-10-21T18:52:58Z https://communities.sas.com/t5/Statistical-Procedures/SAS-Add-in/m-p/586427#M28705 <P>I made a pivot table in excel using SAS Add in, when I connect excel in SAS base data set the data field changes the format, in SAS the format is mmddyy10. already in excel appears as numeric, someone tell me a solution?</P><P>Thank you</P><P>&nbsp;</P><P>&nbsp;</P><P>PROC SQL;<BR />CREATE TABLE SEG4.TB_SMS_SENT_CPF AS<BR />SELECT DATA_EVENTO format=mmddyy10. as DATA_EVENTO</P> Thu, 05 Sep 2019 14:03:14 GMT https://communities.sas.com/t5/Statistical-Procedures/SAS-Add-in/m-p/586427#M28705 eduardo_pedrosa 2019-09-05T14:03:14Z https://communities.sas.com/t5/Statistical-Procedures/SAS-Add-in/m-p/598214#M29123 Try date9. Mon, 21 Oct 2019 18:52:58 GMT https://communities.sas.com/t5/Statistical-Procedures/SAS-Add-in/m-p/598214#M29123 tomrvincent 2019-10-21T18:52:58Z