just use mdy function data IncurredDate; set work.AngieClaims; newdate=mdy( Mnth, Date, Year); format newdate mmddyy10.; run; ... View more

something like below in SQL proc sql; create table want as select name ,dummy_x ,case when count(dummy_x) -sum(dummy_x) = 0 then "N" else "Y" end as Both from have group by 1; ... View more

check whether you indexes on the column you are joining on. try building indexes on columns you join.   ... View more

this is tricky. Teradata has fast export, which exports rows in bulk instead of row wise from Teradata to SAS. I do not know anything of that sort in oracle. but below few things which I can think may help you optimize moving data from oracle to SAS   1. do not do move data to SAS unless something statistical has to be done, remaining every other can be done in DBMS. Only bring final dataset to SAS, so that you can do the statiisical analysis 2. instead of select * use column names and bring only those columns which you will use in your analysis.   3. bring only amount of data you need for your analysis by using where clause in your explicit pass through. ... View more

 this means you are doing something like    proc sql; connect to oracle(user=user password=password path=path); create table work.job204 as select * from connection to oracle (select * from Employees where jobcode=204); quit;  and not below one. first one is moving data to SAS and second one is creating table in oracle itself. First one will take time because now you are moving data from oracle to SAs, but not in Second one. In second query, time of running query should be about same what you have in sql developer   proc sql; connect to oracle (server=myserver user=myuserid pw=mypass ); execute(create somedb.staging_customer as select * from edwwrkuser.Cusomter table where create_dt between ‘2017-01-01’ and ‘2017-01-31’ ) execute(commit work) by oracle; disconnect from oracle; quit;   ... View more

where are you creating table in SAS or Oracle. please provide complete query, so that someone can help you. ... View more