05-10-2016 12:03 PM
05-10-2016 12:06 PM
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 ;
05-10-2016 12:23 PM
Need further help from the community? Please ask a new question.