Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- proc sql;
- connect to mysql(user = 'xxxxx' pass = 'xxxxx' server = 'localhost');
- execute(set @id = &id.) by mysql;
- execute(select (@lit:=image_text) from quality.links_image_text where image_id = @id) by mysql;
- execute(set @lidx = locate('ninja',@lit)) by mysql;
- execute(set @lidx2 = locate(' ',@lit,@lidx)) by mysql;
- execute(set @lidxd = @lidx2 - @lidx) by mysql;
- execute(set @lf = substr(@lit,@lidx,@lidxd)) by mysql;
- create table asdf as
- select &id. as id, a as ws from connection to mysql
- (select @lf as a)
- ;
- disconnect from mysql;
- quit;
- libname db <database> path=dbserver user=... password=...;
- proc sql;
- create table db.new as
- select * from db.largedata where flag=1;
- quit;
- proc sql;
- connect dbase (server=dbserver user=... password=...);
- execute (create table db.new as
- select * from db.largedata where flag=1) as dbase;
- disconnect dbase;
- quit;
Add Comment
Please, Sign In to add comment