SAS Add-in

[eduardo_pedrosa]

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?

Thank you

PROC SQL;
CREATE TABLE SEG4.TB_SMS_SENT_CPF AS
SELECT DATA_EVENTO format=mmddyy10. as DATA_EVENTO

[tomrvincent · Accepted solution]

Try date9.