Then go @Reeza's route
data table1;
set table;
format Var1 Var2 Var3 ddmmyy8.;
run;
all other vars will keep their original format (or lack of).
You can use T1.* but then you can't specify the date.
If ALL your columns are date and it's a straight select it's probably easier to use a data step.
data table1;
set table;
format _numeric_ ddmmyy8.;
run;
Another little trick I use is the FEEDBACK option. Look at the log after this submission and see the full code expanded so it's easier to modify then.
PROC SQL FEEDBACK ;
create table table1 as
Select t1.*
From work.table t1 ;
Quit ;
Would it be fair to assume that date variables include the word DATE in their name?
Then go @Reeza's route
data table1;
set table;
format Var1 Var2 Var3 ddmmyy8.;
run;
all other vars will keep their original format (or lack of).
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.