DATA Step, Macro, Functions and more

Proc sql

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

Proc sql

PROC SQL ;
create table table1 as
Select /*all the columns*/
T1.date FORMAT=DDMMYY8. ,
T1.bithdaydate FORMAT=DDMMYY8. ,
From work.table t1 ;
Quit ;

That's what i want to produce because my dates are in number format ...
However i want to avoid writting all the column's name .
Thanks for your help !

Regards ,
Iris

Accepted Solutions
Solution
‎05-10-2016 04:58 PM
Respected Advisor
Posts: 4,646

Re: Proc sql

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).

PG

View solution in original post


All Replies
Super User
Posts: 17,826

Re: Proc sql

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 ;
Occasional Contributor
Posts: 5

Re: Proc sql

Thank you very much for the tips .

All my column are in different formats ... That's why i can't change all the column's formats into date format .
The t1* as you said is bit working in my situation ...
Regards
Respected Advisor
Posts: 4,646

Re: Proc sql

Would it be fair to assume that date variables include the word DATE in their name?

PG
Occasional Contributor
Posts: 5

Re: Proc sql

No but , there are only 6 so i don't mind writting them manualy , it's more writting all the other that is complicated .
Thanks for your help
Solution
‎05-10-2016 04:58 PM
Respected Advisor
Posts: 4,646

Re: Proc sql

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).

PG
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 261 views
  • 0 likes
  • 3 in conversation