LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2006, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 6 Oct 2006 16:44:59 -0400
Reply-To:   Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject:   Re: proc sql
Comments:   To: Ryan McNeill <RMcNeill@Oklahoman.com>
In-Reply-To:   <BA3F4D45820B6B42ABDB10BB82D4ADDE0E62B1B0@exchange-01.opubco.oklahoman.com>
Content-Type:   text/plain; charset="US-ASCII"

Ryan: Ignoring syntax for the moment, the SAS dataset that you are creating does not support an integer data type. Once written to a SAS dataset, the values will have a NUMERIC (real number) data type. Depending on how you plan to use the ID, that could complicate matters.

The trailing comma in the column definitions generates the syntax error. Fix that and you'll have an empty dataset with a label header. Sig

-----Original Message----- From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu] On Behalf Of Ryan McNeill Sent: Friday, October 06, 2006 4:31 PM To: SAS-L@LISTSERV.UGA.EDU Subject: proc sql

can someone tell me what i'm doing wrong here? help?

PROC SQL;

CREATE TABLE schedule_e

(

Transaction_Id INTEGER not null,

Description VARCHAR(250),

Purpose VARCHAR(250),

);

quit;

i'm getting the following error msg:

353 PROC SQL;

354 CREATE TABLE schedule_e

355 (

356 Transaction_Id INTEGER not null,

357 Description VARCHAR(250),

358 Purpose VARCHAR(250),

359 );

-

22

76

ERROR 22-322: Expecting keyword.

ERROR 76-322: Syntax error, statement will be ignored.

359! );

-

22

ERROR 22-322: Syntax error, expecting one of the following: CHAR, CHARACTER, DATE, DEC, DECIMAL,

FLOAT, INT, INTEGER, NUM, NUMERIC, REAL, SMALLINT, VARCHAR.

360 quit;

<http://www.newsok.com/> <http://www.newsok.com/> Now, you're ready!

Ryan McNeill Database Editor The Oklahoma Publishing Co

<http://maps.google.com/maps?q=9000%20Broadway%20ext%20Oklahoma%20City%2 073114> 9000 N Broadway Oklahoma City, OK 73114 <mailto:rmcneill@oklahoman.com> rmcneill@oklahoman.com <http://www.newsok.com/> http://www.newsok.com tel: 405 475-3694 fax: 405 475-3183


Back to: Top of message | Previous page | Main SAS-L page