LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (April 2007, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Tue, 3 Apr 2007 09:33:37 -0700
Reply-To:   azaufan <azaufan@GMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   azaufan <azaufan@GMAIL.COM>
Organization:   http://groups.google.com
Subject:   proc sql pass-thru and format option
Comments:   To: sas-l@uga.edu
Content-Type:   text/plain; charset="iso-8859-1"

I'm using proc sql to connect to db2 and want to apply a date format to a created column ...below is the example...DB2 doesn't seem to like the format option no matter where i put it. Can this be fixed?

EXAMPLE 1: proc sql; connect to db2 (database=XXXXX ril=ur); create table lib1.table as select * from connection to db2 (select a, b, c (format date9.) from tablename group by a,b,c order by a,b,c ); quit; run;

OR

proc sql; connect to db2 (database=XXXXX ril=ur); create table lib1.table (c format=date9.) as select * from connection to db2 (select a, b, c from tablename group by a,b,c order by a,b,c ); quit; run;


Back to: Top of message | Previous page | Main SAS-L page