topic Not able to insert multiple values at a time by "insert into" in proc sql. in SAS Procedures

Not able to insert multiple values at a time by "insert into" in proc sql.

Arjun_Singh — Thu, 22 May 2014 17:45:18 GMT

Please do me a favour , I am trying to insert multiple rows in the table in db2 database via sas but i am not able to insert multiple rows at a time.

when i use

insert into table_name (a,b,c)

values('a',2,3);

it works but when i use

insert into table_name

select a,b,c

from table2.

then it is not working.

i am getting the error.

I am using SAS EG 6.0.

Re: Not able to insert multiple values at a time by "insert into" in proc sql.

DBailey — Thu, 22 May 2014 18:26:23 GMT

I think your syntax might be wrong:

proc sql;

insert into table_name(a,b,c)

select a,b,c from table2;

quit;

Re: Not able to insert multiple values at a time by "insert into" in proc sql.

Arjun_Singh — Fri, 23 May 2014 17:09:42 GMT

Hi DBailey,

I used the same syntax as you wrote(correct one) but i am getting the error when i am trying to insert multiple rows at a time but not for a single row.

Re: Not able to insert multiple values at a time by "insert into" in proc sql.

Amir — Fri, 23 May 2014 17:20:03 GMT

Hi,

If your table structures are the same, have you tried something like the following (untested):

insert into want

select * from have;

Regards,

Amir.

Re: Not able to insert multiple values at a time by "insert into" in proc sql.

JVarghese — Fri, 23 May 2014 17:23:45 GMT

try adding the clause values before select clause

Re: Not able to insert multiple values at a time by "insert into" in proc sql.

stat_sas — Fri, 23 May 2014 18:28:44 GMT

It seems variables in table_name and table2 have different attributes. Try Proc contents to make sure both tables have same type of variables.