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");
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
>42 item = 'Item purchased '
>43 units = '# Units purchased '
>44 unitcost = 'Unit cost'
>45 format unitcost dollar12.2;