Hello everyone,   I am trying to insert something to different oracle database from my SAS dataset. As usual, the syntax of selecting table from other database is select * from otherowner.tablename;  Let say I have a SAS dataset aaa.   proc sql noprint; connect to oracle (user=xxx password=xxx path=xxx); execute (insert into otherowner.tablename select * from work.aaa) by oracle; disconnect from oracle; quit; It seems that SAS seek "otherowner" as libname to operate the above statement.   Meanwhile, I have tried to add preserve_comments, i.e, proc sql noprint; connect to oracle (user=xxx password=xxx path=xxx preserve_comments=YES); execute (insert into /*otherowner.tablename */ select * from work.aaa) by oracle; disconnect from oracle; quit; However, this is also not working.   Could any expert advise how to implement what I want to execute. Many thanks. ... View more

Hi everyone.   This time, I would like to use loop transformation to pass a date9. value to another job.                 In the picture,       date_from and date_to are date 9. format.   As I know, all date format are regarded as integer. Therefore, when I set the parameter (date_from) in another job. it is also integer. when I type %put &date_from, it gives me 20636, which is not 01JUL2016.   So what can I set to get back the value with date9. format. i.e,  %put &date_from --> 01JUL2016     Thanks ... View more

Hi all,    I would like to check whether a dataset exist first then join the dataset with another dataset. Below is my code: if (exist(ot_reclus_kw_kc)) then do; data semi_ot_result; set ot_reclus_kw_kc semi_ot_result; run; end; Is there any errors/mistakes?   Thanks. ... View more

Background: I have one row record.   and the expexted result is as follow:   Is there ant methods to perform it efficiently in SAS DI? As I have tried using transpose transformation and it just allows me to transpose one column to one output column each time, i.e, I need to perform the transformation 2 times to achieve the above results. ... View more

Hello, everyone, another funny issue.   I would like to use sas di to navigate a website. Is there any suggestion to do it, say just want to visit http://google.com   I have searched for SOAPand RESTtransformation, seems SOAPis not suitable as it is about web service on the server. REST would be similar what I want to do.   Thanks ... View more