Connecting to SAS Viya for Learners from a Remote Jupyter Notebook
Recent Library Articles
Recently in the SAS Support Community: A few weeks ago, SAS' @joeFurbee fielded a communiy question: "Can we connect SAS Viya for learners from macOS terminal via Python SWAT library?" His answer: Yes! In this post, he details how you can connect to SAS Viya using the SWAT package.
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;
... View more
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
... View more
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
... View more
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;
... View more
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.
... View more