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: 
Francisco_Cab
‎04-22-2019
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Oracle connection error

by Calcite | Level 5 in SAS Programming
‎03-26-2019 10:57 AM
‎03-26-2019 10:57 AM
Thanks for your reply.   Is there any information with the steps required to do that?   Best regards, Francisco     ... View more

Re: Oracle connection error

by Calcite | Level 5 in SAS Programming
‎03-26-2019 09:48 AM
‎03-26-2019 09:48 AM
Thanks for your reply.   I am running SAS in my own computer.   This is the error mesage: 1 PROC SQL NOPRINT; 2 CONNECT TO ODBC AS MYDB (DSN="tcerdos" USER="PRODUCCION" PASSWORD=XXXXXX AUTOCOMMIT=YES); ERROR: CLI error trying to establish connection: [Microsoft][Administrador de controladores ODBC] La arquitectura del DSN especificado no coincide entre el controlador y la aplicación. 3 CREATE TABLE THOSEPESKYITEMS AS 4 SELECT * FROM CONNECTION TO MYDB (SELECT * FROM MYIDS); ERROR: The MYDB engine cannot be found. ERROR: A Connection to the MYDB DBMS is not currently supported, or is not installed at your site. 5 QUIT; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.13 seconds cpu time 0.00 seconds   Your help will be greatly appreciated,   Best regards, Francisco ... View more

Oracle connection error

by Calcite | Level 5 in SAS Programming
‎03-22-2019 02:53 PM
‎03-22-2019 02:53 PM
Hi All,   I am trying to connect SAS to an Oracle data base without success (my SAS has ODBC). Is there anything else that I need to do in SAS?. Any help provided will be greatly appreciated.   I am using the following code:   PROC SQL NOPRINT; CONNECT TO ODBC AS MYDB (DSN="xxxxx" USER="xxxxx" PASSWORD="xxxxx AUTOCOMMIT=YES); CREATE TABLE THOSEPESKYITEMS AS SELECT * FROM CONNECTION TO MYDB (SELECT * FROM MYIDS); QUIT;   Best regards,   ... View more

Help

by Calcite | Level 5 in SAS Programming
‎03-06-2019 02:48 PM
‎03-06-2019 02:48 PM
Hi all,   I have a large data set with ID, PARITY, BREEDING DATE, FARROWING DATE AND WEANING DATE variables. I need to create a new variable that can show the weaning date of the previous PARITY within the same ID. In all PARITY 1 I need a "." in the NEW VARIABLE.   This is what I need to achieve:     Any help provided will be greatly appreciated!!!   Best regards, Francisco ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-22-2019 08:08 PM
Quick links