Home

shlomiohana

Hello, I wrote the following code, I would appreciate it if you could improve it for a shorter and more elegant writing. proc sql noprint; create table AAA as select t1.* from CM_EMAIL_SEND t1 left join CM_TEST_CUSTOMERS t2 on lowcase(t1.email)=lowcase(t2.email) where t2.email is null; select count(*) into :row_count from AAA; quit; %put the number: &row_count; %MACRO test; %IF &row_count. gt 0 %THEN %DO; data CM_EMAIL_CHASOM; set CM_EMAIL_CHASOM AAA(in=new); if new then SINUN= 'CM'; run; proc sql; delete from CM_EMAIL_SEND where email in (select email from AAA); quit; %END; %MEND test; %test;

freshstarter

Hello, Recently I have installed snowflake odbc driver on linux server and already we had sql server odbc driver installed. Now we have two different odbc.ini file. I have included all the connection parameters in the new odbc.ini file relates to snowflake and updates the library path in sasenv_local file. The connection to snowflake is working fine from SAS libname statement. But the connection to SQL server is not working. I defined the values as like below export ODBCHOME:/sas/AccessClients/9.4/SQLServer:/etc export LD_LIBRARY_PATH:$ODBCHOME/lib:/etc/snowflake_ODBC/lib:/usr/lib64:$LD_LIBRARY_PATH export ODBCINI:/sas/AccessClients/9/4/SQLServer/odbc.ini:/etc/odbc.ini export ODBCINST:/sas/AccessClients/9/4/SQLServer/odbcinst.ini:/etc/odbcinst.ini export SIMBAINI:/etc/snowflake_ODBC/lib/simba.snowflake.ini /etc is where snowflake driver is installed and SQLServer is under /sas/AccessClients. Kindly suggest how to edit this file to have both the connection working properly. Thanks

robertrao

I posted this question earlier but didnt get what i needed so reposting it. It is seen that the rating for Established patients was very high for the questions. ( All the data is not shown) We waned to see for which "questions" between the two groups ( established or NEW) there was a statistically significant difference??? Please let me know how can we solve this Thank you ID DOMAIN QUESTION SCORE APPOINTMENT_TYPE 101 Med Practice: Care Provider Med Practice: CP Concern 100 Estblished 101 Med Practice: Care Provider Med Practice: CP Explanation 100 Estblished 101 Med Practice: Care Provider Med Practice: CP Discuss treatments 100 Estblished 101 Med Practice: Care Provider Med Practice: CP Efforts 100 Estblished 101 Med Practice: Access Med Practice: Ease of contacting 100 Estblished 101 Med Practice: Access Med Practice: Ease of scheduling 100 Estblished 101 Med Practice: Access Med Practice: CP Efforts 100 Estblished 102 Med Practice: Care Provider Med Practice: CP Concern 100 New 102 Med Practice: Care Provider Med Practice: CP Explanation 100 New 102 Med Practice: Care Provider Med Practice: CP Discuss treatments 100 New 102 Med Practice: Care Provider Med Practice: CP Efforts 100 New 102 Med Practice: Access Med Practice: Ease of contacting 100 New 102 Med Practice: Access Med Practice: Ease of scheduling 100 New 102 Med Practice: Access Med Practice: CP Efforts 100 New

ChrisWoo

Hi guys, would like to ask why i cant convert numeric to character with decimal places of 2 ? i use the wrong format ? Numeric value = 0.250000 Value (character) i want = 0.25 extract from my code: put(from_numeric_value,20.6) %let sdis6_decimal_0 = "loanpurpose","original_tenure","principal_repay_term","specific_dfi_financing_details","startup_financing","refinance"; %let sdis6_decimal_2 = "interest_rate","rebate_rate","value_of_asset_purchase","dsr","refinance_value","eir","pod_original"; data work.AuditLog_Mart_SDIS6 (/*drop=from_numeric_value to_numeric_value*/ rename=(update_field=Variable) compress=yes ); set prccris.ccris_audit_log; where sdis_filename = "SDIS6" and position_dt="&position_dt"d; /* Note: Transform numeric to string and remove blanks space*/ if update_field in (&sdis6_decimal_0) then do; from_numeric_value_c = strip(ifc(missing(from_numeric_value),"",put(from_numeric_value,20.0))); to_numeric_value_c = strip(ifc(missing(from_numeric_value),"",put(from_numeric_value,20.0))); deci_tag = "0 deci"; end; else if update_field in (&sdis6_decimal_2) then do; from_numeric_value_c = strip(ifc(missing(from_numeric_value),"",put(from_numeric_value,20.6))); to_numeric_value_c = strip(ifc(missing(from_numeric_value),"",put(from_numeric_value,20.6))); deci_tag = "2 deci"; end; from_character_value = strip(from_character_value); to_character_value = strip(to_character_value); run;

SAS_TSNEWS

A new update is available for SAS/ACCESS Interface to Teradata , version 9.48 : Hot Fix: N4V002 - Published 11OCT2024 , Download link for N4V002 Component name: SAS/ACCESS Interface to Teradata Related SAS release: 9.4 Issues addressed in N4V002 This list of notes might be incomplete. For a complete list of issues addressed by this hot fix, visit the hot fix page for N4V002 Note: A comprehensive list of all SAS hot fixes is available from support.sas.com. You can use the SAS Hot Fix Analysis, Download, and Deployment (SASHFADD) tool to manage your SAS hot fixes.