06-22-2016 08:31 AM
I am using SAS University Edition and am connecting to the SQL database using PCFiles as described in below link.
Now I want to push the data from SAS to SQL Table. Pl. suggest an appropriate way to achieve this.
Thanks in Advance.
06-22-2016 08:48 AM
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:
set <database_libname>.<database_table_name> <your_new_data>;
06-22-2016 11:08 PM
I don't know if it could work, I never test it before.
1) libnanme z ......... /* NO access=readonly option*/
proc copy in=SAS_lib out=SQL_lib;
insert into SQL_lib.want
select * from SAS_lib.want;
2)PROC DBLOAD .
connect to pcfiles();
execute( inset into ......... )