Hello - I'm trying to run the below code but its taking hours.  What can I do to improve the efficiency of this program so it doesn't take so long to run?   Thanks!   %let user = xxxxx; %let pswd = "%STR({SAS002}EE9F3A145162A68C09E176074A3382401380A5B759B196C62EF8B5D5)";   libname here '/workspace/cucr/risk/userid/xxxxx';   proc sql; options nomprint; connect to oracle as adm (USER=&user. PASSWORD=&pswd. PATH="prod"); options mprint;   create table here.v_chd_mini_month_end (compress=yes) as select * from connection to adm (select chd_open_date, tape_date, chd_credit_line, chd_account_number_ref, chd_cr_line_date from adm.v_chd_mini_month_end order by chd_account_number_ref, tape_date);   disconnect from adm; quit; ... View more

How would i write the following %sort statement using proc sort?   %sort(data.rade,camp_cd appl_id RADE_RELSHIP_TYP RADE_ACCT_NO,option=nodupkey)   I believe it would be:   proc sort data=data.rade nodupkey;       by camp_cd appl_id RADE_RELSHIP_TYP RADE_ACCT_NO; run;   Is this correct/will give me the same results?  Also, can %sort be used outside of a macro?   Thanks!   ... View more

I'm seen people use the following mehtod for a libname:   libname a '.';    What's the reason for doing this?     Thanks! ... View more

Hi All, Recently I took a SQL query that I was running in Teradata SQL Assistant and wrote it in SAS using Proc SQL.  My intend was to get the same results in SAS as I was getting the script in Teradata SQL Assistant.  The Proc SQL code works, however I'm getting slightly different results and I'm not sure why.  Does anyone know what I might be missing?  Thanks!   Teradata SQL Assistant code: Select PERIOD_DT as "Date" ,APPL ,CUST_TYPE_IND ,SUBPROD_CODE ,left(NAICS_Code,2) as "NAIC 2 Digit" ,CUOV_BUSN_TYPE ,sum(CUR_BAL) as "Balance" From eiw_d_bicc_hgnids_v1.depsme_jv IDS left join CIS.CUSTOMER_TB Cust on IDS.CIS_CUST_NO = Cust.Cust_NBR and cust.Close_date is null Left Join CIS.Cust_OV_TB CUOV On CUST.Cust_CO_NBR = CUOV.Cust_CO_NBR and CUST.CUST_ID = CUOV.CUST_ID AND CUST.CUST_TIE_BRKR = CUOV.CUST_TIE_BRKR left join PCD.NAICS_TB NAIC on Cust.NAIC_CD = NAIC.NAICS_Code where IDS.PERIOD_DT = '2021-05-31' and IDS.CUR_BAL >0 and CUST_TYPE_IND <> 0 and IDS.CUR_BAL <1000000 and NAIC.NAICS_Code not in ( '521110', '522110', '522120', '522130', '522190', '522210') group by 1,2,3,4,5,6   SAS Proc SQL code: data _null_; call Execute('%include "/users/apps/rbr_rpa/&sysuserid/pw/teradata_credentials.sas " / source2;'); run; libname teralib1 teradata server='XXXXX' user=&tduser password=&pw database='eiw_d_bicc_hgnids_v1'; libname teralib2 teradata server='XXXXX' user=&tduser password=&pw database='CIS'; libname teralib3 teradata server='XXXXX' user=&tduser password=&pw database='PCD' mode=teradata; proc sql; create table small_business as select depsme_jv.PERIOD_DT as Date, depsme_jv.APPL, CUSTOMER_TB.CUST_TYPE_IND, depsme_jv.SUBPROD_CODE, substr(naics_tb.NAICS_Code,1,2) as NAIC_2_Digit, cust_ov_tb.CUOV_BUSN_TYPE, sum(depsme_jv.CUR_BAL) as Balance from teralib1.depsme_jv left join teralib2.customer_tb on depsme_jv.cis_cust_no = customer_tb.Cust_NBR and customer_tb.close_date is null left join teralib2.cust_ov_tb on customer_tb.Cust_CO_NBR = cust_ov_tb.Cust_CO_NBR and customer_tb.CUST_ID = cust_ov_tb.CUST_ID and customer_tb.CUST_TIE_BRKR = cust_ov_tb.CUST_TIE_BRKR left join teralib3.naics_tb on customer_tb.naic_cd = naics_tb.naics_code where depsme_jv.PERIOD_DT='31May2021'd and depsme_jv.cur_bal > 0 and CUSTOMER_TB.cust_type_ind ~="0" and CUSTOMER_TB.cust_type_ind is not null and depsme_jv.cur_bal < 1000000 and naics_tb.naics_code not in('521110', '522110', '522120', '522130', '522190', '522210') and naics_tb.naics_code is not null group by 1,2,3,4,5,6; quit; libname teralib1 clear; libname teralib2 clear; libname teralib3 clear; ... View more