SAS_Learner ,

You can do what you want, Yes you can use a label statement as well as a
format statement.  Teo things you need to do, lose the parens and the
format.  Ther label and format statements are giving you the error, teh
particular construct of these you have choosen to use are not aplicable
within sql.  But SQl has its own constructs to achieve the same thing.

Try the following:


proc sql ;
create table test as <---- Need a 'as' here
Select Customer Format = $char4.    Label ='Customer number  '  ,
           Item       Format = $char10.  Label = 'Item purchased    '  ,
           units       Format = 8.           Label = '# Units purchased '  ,
           unitcost  Format = Dollar12.2 Label = 'Unit cost'
  From < you didnt have anything here but you need to refernece a data set>
;
quit ;



Toby Dunn





From: SAS_learner <proccontents@GMAIL.COM>
Reply-To: SAS_learner <proccontents@GMAIL.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: why is this warning(error) ??????????
Date: Tue, 20 Jun 2006 23:46:02 -0400

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;