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: 
CG11164
‎07-28-2019
  • 7 Posts
  • 0 Likes Given
  • 1 Solutions
  • 0 Likes Received

Re: DBMS Access error

by Fluorite | Level 6 in SAS Programming
‎07-24-2019 05:34 PM
‎07-24-2019 05:34 PM
Tried to remove company info and apparently it didn't work.  let me get you a clean slate of the code and runs.  Thanks ... View more

Re: DBMS Access error

by Fluorite | Level 6 in SAS Programming
‎07-24-2019 04:49 PM
‎07-24-2019 04:49 PM
Code:   libname GRPDB "C:\Users\one\Documents\Group"; %let curlib=cgDB;   %let accessdb="C:\Users\one\Documents\SAS Files\GroupSAS.mdb"; options fmtsearch=(sasuser &curlib.); options cmplib=sasuser.funcs;   PROC IMPORT OUT= &curlib..CountsAll DATATABLE= "Counts" DBMS=ACCESSCS REPLACE; DATABASE=&accessdb.; SCANMEMO=YES; USEDATE=YES; SCANTIME=NO; RUN; PROC IMPORT OUT= &curlib..SummaryT DATATABLE= "CountsAct" DBMS=ACCESSCS REPLACE; DATABASE=&accessdb.; SCANMEMO=YES; USEDATE=YES; SCANTIME=NO; RUN; ... View more

Re: DBMS Access error

by Fluorite | Level 6 in SAS Programming
‎07-24-2019 04:32 PM
‎07-24-2019 04:32 PM
proc product_status;run; For Base SAS Software ... Custom version information: 9.4_M6 Image version information: 9.04.01M6P110718 For SAS/STAT ... Custom version information: 15.1 For SAS/GRAPH ... Custom version information: 9.4_M6 For High Performance Suite ... Custom version information: 2.2_M7 For SAS/ACCESS Interface to PC Files ... Custom version information: 9.4_M6 NOTE: PROCEDURE PRODUCT_STATUS used (Total process time): real time 0.04 seconds cpu time 0.01 seconds ... View more

Re: DBMS Access error

by Fluorite | Level 6 in SAS Programming
‎07-24-2019 03:51 PM
‎07-24-2019 03:51 PM
SAS help desk had me install the 32 bit SAS version on my 64 bit machine so it would work better with the 32 bit office.  They said I should not be getting this error however, still getting it.     ... View more

DBMS Access error

by Fluorite | Level 6 in SAS Programming
‎07-24-2019 02:30 PM
‎07-24-2019 02:30 PM
Any suggestions for what is causing this error?  I am getting it on all PROC IMPORT OUT with Access   Relatively new to SAS programming so any suggestions are appreciated.  Using SAS 9.4 running 32 bit on 64 bit machine with 32 bit office.   PROC IMPORT OUT= &curlib..CountsAll 27 DATATABLE= "CountsPool" 28 DBMS=ACCESS REPLACE;     ERROR: DBMS type ACCESS not valid for import. ... View more

Re: Issue with PC file Server 9.4

by Fluorite | Level 6 in SAS Programming
‎07-24-2019 12:48 PM
‎07-24-2019 12:48 PM
I do get the line in the log you list.  I haven't had to use the PC File server before so will need to locate documentation on configuring it.    Thanks ... View more

Issue with PC file Server 9.4

by Fluorite | Level 6 in SAS Programming
‎07-24-2019 10:23 AM
‎07-24-2019 10:23 AM
When I have been importing data from 32 bit office into Sas 9.4 I had a drop down box that allowed me to choose PC File Server Excel from the IMPORT Wizard.  Not sure what happened on my system but that option is gone and I can only choose from csv, Tab Delimited, Delimited and JMP.   Does anyone know how to get the IMPORT options back?  I have reinstalled multiple times - nothing seems to be working.   Thank you ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-28-2019 10:07 AM
Quick links