topic Insert Data into Sql Table from SAS University Edition in SAS Programming

Insert Data into Sql Table from SAS University Edition

chaitalip — Wed, 22 Jun 2016 12:31:32 GMT

Hi,

I am using SAS University Edition and am connecting to the SQL database using PCFiles as described in below link.

https://communities.sas.com/t5/SAS-Analytics-U/Connect-to-SQL-Server-Oracle-Database-by-SAS-University-Edition/m-p/273857/highlight/true#M3724

Now I want to push the data from SAS to SQL Table. Pl. suggest an appropriate way to achieve this.

Thanks in Advance.

Re: Insert Data into Sql Table from SAS University Edition

RW9 — Wed, 22 Jun 2016 12:48:04 GMT

So what have you done from that post, as it gives you the answer. Create a libname to the database, then datastep set your new data with and existing one:

data <database_libname>.<database_table_name>;

set <database_libname>.<database_table_name> <your_new_data>;

run;

Re: Insert Data into Sql Table from SAS University Edition

Reeza — Wed, 22 Jun 2016 13:07:56 GMT

It's not officially supported.

Re: Insert Data into Sql Table from SAS University Edition

Ksharp — Thu, 23 Jun 2016 03:08:59 GMT

I don't know if it could work, I never test it before.

1) libnanme z ......... /* NO access=readonly option*/

data SQL_lib.want;

set SAS_lib.want;

run;

proc copy in=SAS_lib out=SQL_lib;

select want;

run;

OR SQL

proc sql;

insert into SQL_lib.want

select * from SAS_lib.want;

quit;

2)PROC DBLOAD .

3)Pass-through

proc sql;

connect to pcfiles();

execute( inset into ......... )

by pcfiles;

quit;