cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
psgard
‎09-22-2022
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: Encoding trouble UTF-8 vs LATIN1 with SAS ACCESS TO ODBC Configura...

by Fluorite | Level 6 in Administration and Deployment
‎11-25-2020 03:21 AM
‎11-25-2020 03:21 AM
Hello,   All SAS Databases in our Platform are in LATIN1, if i modify the SAS session encoding in the file: /sas/software/SASFoundation/9.4/bin/sasenv_local won't there be another problems reading my existing SAS databases or joining/merging sas database and snowflake database  (in proc sql for example) ? ... View more

Re: Encoding trouble UTF-8 vs LATIN1 with SAS ACCESS TO ODBC Configura...

by Fluorite | Level 6 in Administration and Deployment
‎11-25-2020 03:11 AM
‎11-25-2020 03:11 AM
Hello MargaretC,   I have already checked this part with isql directly on the Linux server. I think that the trouble is "between" SAS and the driver Linux Snowflake.   result of the isql query:   SQL>  select CLBR_CTRA_TYPE_LB from BPFR_MEDIUM.BPFR_MEDIUM_VIEW.DIM_CLBR where clbr_sk = 11036 and tec_current_in = 1; +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | CLBR_CTRA_TYPE_LB                                                                                                                                                                                       | +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Contrat à durée indéterminée                                                                                                                                                                        | +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ SQLRowCount returns 1 1 rows fetched         ... View more

Re: How to test the existence of a database Teradata before logging on

by Fluorite | Level 6 in SAS Programming
‎11-24-2020 05:46 PM
‎11-24-2020 05:46 PM
Hello,   Sorry for the late answer.   I want to create a generic autoexec.sas for all users in my organization. In the autoexec.sas i want to define main libnames  (Oracle, Teradata, or SAS databases). But i my organization, there are a lot of user profiles and not all of them have the same rigths to data libraries. If i set a libname on a data library on which the user does'nt have rights to access, the autoexec.sas will send an error. So i want the autoexec to test if the libname can be set without error.   Thanks Best regards   ... View more

Encoding trouble UTF-8 vs LATIN1 with SAS ACCESS TO ODBC Configuration...

by Fluorite | Level 6 in Administration and Deployment
‎11-24-2020 05:30 PM
‎11-24-2020 05:30 PM
Hello,   I work in SAS GRID 9.4 on a Redhat 7 Linux platform. I want to access to Snowflake Data with a SAS ACCESS TO ODBC connector. Snowflake Encoding : UTF-8 Linux encoding (echo $LANG) : en_US.UTF-8 SAS Platform encoding (proc options group=languagecontrol; run;) :  ENCODING=LATIN1 / LOCALE=EN_US  SAS ACCESS TO ODBC doesn't manage option encoding. When I read a database with special UTF-8 characters (é,è,à….), i receive wrong data, for example:"Contrat à durée indéterminée​" I want to receive "Contrat à durée indéterminée". How do i configure my ODBC to obtain this result for all users on my SAS platform, please ?   Thanks, Best regards.         ... View more

Re: How to test the existence of a database Teradata before logging on

by Fluorite | Level 6 in SAS Programming
‎04-23-2020 12:39 PM
1 Like
‎04-23-2020 12:39 PM
1 Like
Hello,   thank you. I used the function and it's ok . I can test and manage libname without ERROR with this function .   /* format convertion code retour en libellé statut de connexion */  proc format;  value LIB_ERR   -70004  = "Connectée"   0  = "Connectée"   70029 = "Non Autorisé"   630081 = "Déjà Connectée"   other = "ERROR"  ;  run;    /* On parcours le référentiel des librairies et on ouvre les libnames */  /* les erreurs de connexion sont tracees dans la table journal */  data PRIVE.LIBRAIRIES;   set SAS_LIB.AUTOEXEC_LIB;   format    RC 10.    DATETIME datetime.   ;   length    RC 8.;   label    RC='Code retour connexion librairie'    STATUT='Statut de la connexion'    MSG = 'Message Erreur'    DATETIME= 'Date et heure de connexion';   RC=libname(LIBNAME, CHEMIN, , );   STATUT=put(RC,LIB_ERR.);   msg=sysmsg();   datetime=datetime();  run;     ... View more

How to test the existence of a database Teradata before logging on

by Fluorite | Level 6 in SAS Programming
‎02-20-2020 12:42 PM
‎02-20-2020 12:42 PM
Hello,   libname DATAB TERADATA user=&userp password=&passwdp server=&serverp database=&dbp_dtm_sellsec; ERROR: Cannot connect to the specified database.  Try changing or removing your DATABASE= option. ERROR: Error in the LIBNAME statement.   This ERROR is normal because the database was unavailable.   I would know how to test if a database Teradata is available or if the user can access to this base before to create the libname or before to do a "connect to Teradata" instruction,  and so to prevent the ERROR Message.   I succeed in testing this with "dopen" for a simple SAS Library , but how to do this for  a Teradata, Oracle or other external database ? Perhaps  with catching ERROR ? But I want not to have the ERROR message in the log of the treatment. At the end of the treatment i want to have a RCode =0.   I use SAS ACCESS TO TERADATA.   Thank for your help.       ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-22-2022 02:19 PM
Likes from
View All
Quick links