Date:         Wed, 21 Jun 2006 10:01:45 GMT
Reply-To:     Eric Eyre <eeyre@CONCENTRIC.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Eric Eyre <eeyre@CONCENTRIC.NET>
Organization: Road Runner High Speed Online http://www.rr.com
Subject:      Re: why is this warning(error) ??????????
Comments: To: sas-l@uga.edu

David

* sure you can

proc sql ;
create table test
(cust char(12) label ='customer',
contdate num label='contact date' format=date7.);
insert into test
values ('Smith',88779);

proc print label noobs;

customer   contact date
Smith        26JAN03

* OR as an alternative

data one;
x=1;

proc sql;
select 'Smith' 'customer', 88779 'contact date' format=date7. from one;

customer   contact date
Smith          26JAN03



Erico


"SAS_learner" <proccontents@GMAIL.COM> wrote in message
news:c2192a610606202046i1e7567a8ye33df8fac8a91c0d@mail.gmail.com...
> 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;