f



Re: why is this warning(error) ??????????

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;
0
tobydunn (6020)
6/21/2006 1:37:06 PM
comp.soft-sys.sas 142828 articles. 2 followers. Post Follow

0 Replies
1483 Views

Similar Articles

[PageSpeed] 13

Reply:

Web resources about - Re: why is this warning(error) ?????????? - comp.soft-sys.sas

State Department will hold back 22 of Clinton's emails today because they are 'top secret'
State is required to release more of Clinton's emails today as part of a court order. It will hold 22 back though because they contain high-level ...

Midday open thread: GDP growth weak in 4th quarter; Native women run for Congress
Today’s comic by Mark Fiore is FDR-Palin endorses Trump! • GDP growth for 4th quarter a paltry 0.7 percent : The Commerce Department reported ...

Hollywood Tees Up Movie Ads For Super Bowl: TV’s Most Expensive Event
Can anyone justify spending $5 million for a 30-second commercial — even one in front of TV’s biggest audience? That’s a trick question. They ...

Kanye West Slammed By Waves Creator Max B After Wiz Khalifa Feud
It’s been a tough week for Kanye West. The rapper got into a heated feud with Wiz Khalifa after he changed his album name from Swish to Waves ...

IOC sends medical advice to Olympic committees on Zika virus
LONDON (AP) — The IOC advised national Olympic committees on Friday to follow the World Health Organization's guidance on dealing with the Zika ...

French Film Industry Pays Homage to Director Jacques Rivette
Jacques Rivette, one of the leading lights of the French New Wave who died on Friday at age 87, was celebrated throughout the day with a series ...

Vietnamese Gang Connected to Escape of 3 Inmates From California Prison, Police Say
Vietnamese Gang Connected to Escape of 3 Inmates From California Prison, Police Say

FBI releases video of militiaman shooting
The FBI has released footage that shows militiaman LaVoy Finicum's death at the hands of law enforcement officers manning a roadblock. In the ...

Wow! This WaPo front-page squib for Paul Kantner irks me.
The Jefferson Airplane was one of the greatest manifestations of the 1960s. Why would you reference a 1980s song — a song many people loathe ...

Syrian opposition will travel to Geneva talks: spokesman
Syria's main opposition body has agreed to travel to Geneva, where peace talks began on Friday, following a phone call from the U.S. Secretary ...

Resources last updated: 1/29/2016 11:18:43 PM