BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Iris83
Calcite | Level 5
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
1 ACCEPTED SOLUTION

Accepted Solutions
PGStats
Opal | Level 21

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

5 REPLIES 5
Reeza
Super User

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 ;
Iris83
Calcite | Level 5
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
PGStats
Opal | Level 21

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

PG
Iris83
Calcite | Level 5
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
PGStats
Opal | Level 21

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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