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;