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).
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.