how to define format when create empty table use sql

[Mike_Davis]

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 · Accepted solution]

http://support.sas.com/documentation/cdl/en/sqlproc/62086/HTML/default/viewer.htm#a001384767.htm

GOOGLE SEARCH WORDS: SAS SQL TABLE CREATION

[Mike_Davis]

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:

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002294522.htm

Mike