topic Re: how to define format when create empty table use sql in SAS Procedures

how to define format when create empty table use sql

Mike_Davis — Tue, 11 Sep 2012 19:12:02 GMT

Hello everyone,

In the code below:

I want column dt with format date9. how to modify the code?

Thanks

Mike

proc sql;

create table empty(

id int,

dt date,

name varchar(30)

)

;

quit;

Reeza — Tue, 11 Sep 2012 19:23:36 GMT

GOOGLE SEARCH WORDS: SAS SQL TABLE CREATION

Mike_Davis — Tue, 11 Sep 2012 19:32:56 GMT

Thank you Reeza!

not only for resolve my problem but also you share with me the method to seach on google.

infact I make a search like you tell me and get the first result is:

Mike