Help using Base SAS procedures

how to define format when create empty table use sql

Accepted Solution Solved
Reply
Regular Contributor
Posts: 222
Accepted Solution

how to define format when create empty table use sql

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;


Accepted Solutions
Solution
‎09-11-2012 03:23 PM
Super User
Posts: 19,770

Re: how to define format when create empty table use sql

Posted in reply to Mike_Davis

All Replies
Solution
‎09-11-2012 03:23 PM
Super User
Posts: 19,770

Re: how to define format when create empty table use sql

Posted in reply to Mike_Davis
Regular Contributor
Posts: 222

Re: how to define format when create empty table use sql

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

🔒 This topic is solved and locked.

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

Discussion stats
  • 2 replies
  • 716 views
  • 0 likes
  • 2 in conversation