Create Table Error

Database
N/A

Create Table Error

Hello Everyone,

I am new at Teradata.  I am trying to create a temporary teradata table in SAS and got the following error.  It doesn't like the  advr_imprs_ckid_id (8) .  I hope i have given enough information for my question.  I really appreciate any input from anyone. 

Thank you!

ERROR: Teradata execute: Syntax error, expected something like a 'CHECK' keyword or an 'UNIQUE'

keyword between the word 'advr_imprs_ckid_id' and '('.

PROC SQL;

CONNECT TO &rchtera;

EXECUTE (

CREATE MULTISET TABLE USER_CPORTIM.cm_imp

,NO FALLBACK

,NO BEFORE JOURNAL

,NO AFTER JOURNAL

,CHECKSUM = DEFAULT

(

advr_imprs_ckid_id (8)

, advr_imprs_ckid_tx

, sessn_srogt_key_id

, imp_25(8)

, imp_28(8)

 

)

PRIMARY INDEX ( advr_imprs_ckid_id )

) BY TERADATA;

%PUT CREATE SQLXRC : &SQLXRC;

%PUT CREATE SQLXMSG: &SQLXMSG;

DISCONNECT FROM TERADATA;