proc sql;

create table data as

select

date_column format YYMMDDN.

, column_1

, column_2

, column_3

from source_table;

quit;

https://documentation.sas.com/doc/en/ds2pg/3.2/p0bz5detpfj01qn1kz2in7xymkdl.htm

here are the other types of date formats you can use in SAS enterprise i think YYMMDDN. gives you the YYYYMMDD format you are looking for...