This worked!!! I had the PATH name incorrect.  When I removed LAPROD=, it allowed me to make a pass-through connection directly to the Oracle server.  Thanks again!!! ... View more

Thank you for your help!  I greatly appreciate it. ... View more

It looks like I can communicate. Thanks for your assistance! ... View more

Yes, this is already configured.  Below is what I have in my TNSNAMES.ora file.  Do I  need to cut and paste this as the path exactly as below?  Are there any characters I am missing? LAPROD=   (DESCRIPTION=     (ADDRESS=       (PROTOCOL=TCP)       (HOST=10.12.102.60)       (PORT=1521)     )     (CONNECT_DATA=       (SERVICE_NAME=NEOLA.BPWDB.MSDS)     )   ) ... View more

Thank you for your response. Where can I find the PATH name?  I have tried Environmental Variables path, I have tried the server IP and Server name, and I have tried the alias in TNSNAMES.ora file but I continue to get the TNS error.  Any suggestions? ... View more

I am trying to use SAS/ACCESS Interface to Oracle.  I am able to access the Oracle server via the ODBC option; however, it is less efficient. I am trying to create a direct connection to the server as I do with OLEDB to my SQL server.  I thought I could do this with the LIBNAME statement but having a problem with the correct PATH.  ... View more

Yes!!! That did it. Thank you so much for your help!! ... View more

That fixed it!  But how can I make the other observations that are not in a sequence set to 0 or some other flag?  They are being populated with various numbers (i.e. 2, 4, 5, etc.) ... View more

I did not receive any errors or warnings, however, the SAS log is below:                                       The SAS System              07:45 Wednesday, March 4, 2015 1          ;*';*";*/;quit;run; 2          OPTIONS PAGENO=MIN; 3          %LET _CLIENTTASKLABEL='Program'; 4          %LET _CLIENTPROJECTPATH='\\DHH-ISB-FS01\User Folders\kparker\My Documents\SAS Data 4        ! Sets\Readmissions.egp'; 5          %LET _CLIENTPROJECTNAME='Readmissions.egp'; 6          %LET _SASPROGRAMFILE=; 7          8          ODS _ALL_ CLOSE; 9          OPTIONS DEV=ACTIVEX; 10         GOPTIONS XPIXELS=0 YPIXELS=0; 11         ODS LISTING GPATH=&sasworklocation; 12         FILENAME EGHTML TEMP; 13         ODS HTML(ID=EGHTML) FILE=EGHTML ENCODING='utf-8' STYLE=HtmlBlue 13       ! STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/5.1/Styles/HtmlBlue. 13       ! css") 13       ! ATTRIBUTES=("CODEBASE"="http://www2.sas.com/codebase/graph/v93/sasgraph.exe#version=9,3") 13       ! NOGTITLE NOGFOOTNOTE GPATH=&sasworklocation; NOTE: Writing HTML(EGHTML) Body file: EGHTML 14         FILENAME EGRTF TEMP; 15         ODS RTF(ID=EGRTF) FILE=EGRTF ENCODING='utf-8' STYLE=Rtf NOGTITLE NOGFOOTNOTE; NOTE: Writing RTF Body file: EGRTF 16         17         GOPTIONS ACCESSIBLE; 18         DATA rdm2; *not working; 19         SET work.rdm; 20         by encounter_id medrec_no; 21         if first.encounter_id=0 or last.encounter_id=0 22         then duplicate_encounter_data_flag="Y"; 23         if first.medrec_no then do; 24         if last.medrec_no=0 then seqno=1; 25         end; 26         else if first.encounter_id then seqno + 1; 27         run; NOTE: There were 557758 observations read from the data set WORK.RDM. NOTE: The data set WORK.RDM2 has 557758 observations and 13 variables. NOTE: DATA statement used (Total process time):       real time           1.15 seconds       cpu time            1.15 seconds       28         29         GOPTIONS NOACCESSIBLE; 30         %LET _CLIENTTASKLABEL=; 31         %LET _CLIENTPROJECTPATH=; 32         %LET _CLIENTPROJECTNAME=; 33         %LET _SASPROGRAMFILE=; 34         35         ;*';*";*/;quit;run; 36         ODS _ALL_ CLOSE; 37         38         39         QUIT; RUN; 2                                           The SAS System              07:45 Wednesday, March 4, 2015 40         ... View more