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 (June 2006, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 21 Jun 2006 05:14:48 -0400
Reply-To:     Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Subject:      Re: why is this warning(error) ??????????

the label and format statement is not supported in SQL. It looks a bit different there. Try it like:

proc sql ; create table test (customer char(4) "Customer number", item char(10) "Item purchased", units num "# Units purchased", unitcost num(8,2) format=dollar12.2 "Unit cost");

quit;

On Tue, 20 Jun 2006 23:46:02 -0400, SAS_learner <proccontents@GMAIL.COM> wrote:

>Guys I am using SAS 8.2 version on windows xp platform , I am trying to do >something like this and I getting this warning in the Log can some body >explain me why and how to solve it > > proc sql ; >36 create table test >37 (customer char(4) , >38 item char(10) , >39 units num, >40 unitcost num(8,2)); >NOTE: Table WORK.TEST created, with 0 rows and 4 columns. >41 label customer = 'Customer number ' >WARNING: This SAS global statement is not supported in PROC SQL. It has been >ignored. >42 item = 'Item purchased ' >43 units = '# Units purchased ' >44 unitcost = 'Unit cost' >45 format unitcost dollar12.2; >46 quit;


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