Hi, I am newbie for SAS EG, May I need you guy help me about issue, I would like to create the table with specific the data type, then insert the data as select from once table use PROC SQL with Neteza DB, The result create table is working but NOT any data insert to that new table as I have created, my code as below, PROC SQL;
CONNECT TO NETEZZA AS CON1(DATABASE=SAS_ADM SERVER="192.168.00.00" AUTHDOMAIN= "ABC");
EXECUTE(
CREATE TABLE SAS_ADM..TK_TEMP3 (
Center NATIONAL CHARACTER VARYING(10),
FoundSentence NATIONAL CHARACTER VARYING(255)
);
INSERT INTO SAS_ADM..TK_TEMP3
SELECT Center,
FoundSentence
FROM WORK.FILE_TK;
) BY CON1;
DISCONNECT FROM CON1;
QUIT;
... View more