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

Re: Scanning multiple variables to create new variable

by Calcite | Level 5 in SAS Programming
‎04-02-2019 08:59 AM
‎04-02-2019 08:59 AM
Thank you everyone! ... View more

Scanning multiple variables to create new variable

by Calcite | Level 5 in SAS Programming
‎04-01-2019 04:05 PM
‎04-01-2019 04:05 PM
Hi, I need to assess whether data across multiple variables matches.  At the same time I need to bypass missings (not take them into account when determining whether there's a match or non-matching data.  For example, In the data below I would want to note in the first data row that data do not match.  The second data row would be a 'match'.  Thank you! REF1    REF2     REF3     REF4     REF5 123          .               123      124          .     .        124             124         ,            ,    123     123              .            .            . ... View more

Re: Import Access (.accdb) into SAS 9.4 64 bit

by Calcite | Level 5 in SAS Programming
‎06-28-2018 12:25 PM
‎06-28-2018 12:25 PM
Hi Reeza,   I get this message when I use DBMS=PCFILES   996 997 *Import in 64 bit version; 998 proc import DBMS=PCFILES Datatable = 'tblCaseDesignation' 999 out = work.CASEDESIGNATion REPLACE; ERROR: DBMS type PCFILES not valid for import. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.33 seconds cpu time 0.00 seconds   And this when I use DBMS=ACCESS   ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement. ERROR: Connection Failed. See log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.65 seconds cpu time 0.29 seconds   ... View more

Import Access (.accdb) into SAS 9.4 64 bit

by Calcite | Level 5 in SAS Programming
‎06-28-2018 10:57 AM
‎06-28-2018 10:57 AM
I am trying to import an access data table into SAS 9.4. My compute has been upgraded to 64 bit.   I am running 64 bit SAS and Microsoft Office 2016.  I have converted my access database from .mdb to .accdb.   Here's my import program:   proc import DBMS=ACCESScs Datatable = 'tblCaseDesignation' out = work.CASEDESIGNATion REPLACE; Database = "T:\EPI_data\CO Surveillance\CO_Database\CO_casesurveillance_ver5.accdb"; run;   Here's my error message: 2 *Import in 64 bit version; 3 proc import DBMS=ACCESSCS Datatable = 'tblCaseDesignation' 4 out = work.CASEDESIGNATion REPLACE; 5 Database = "T:\EPI_data\CO Surveillance\CO_Database\CO_casesurveillance_ver5.accdb"; 6 run; ERROR: Failed to connect to the Server: . NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.70 seconds cpu time 0.25 seconds   Thank you very much for any help you can offer!   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-02-2019 12:19 PM
Quick links