RTM ??

17   proc sql ;
18      create table test
19         (customer char(4) Label= 'Customer number ',
20          item char(10)       Label='Item purchased ',
21          units num              Label='# Units purchased ',
22          unitcost num(8,2) Label='Unit cost'        format=dollar12.2
23          )
24          ;
NOTE: Table WORK.TEST created, with 0 rows and 4 columns.
25      quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.34 seconds
      cpu time            0.04 seconds



SAS_learner 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;
>
>