I used this code to connect and import from a microsoft access file. Had been doing this for years without problem. Just installed SAS on a new windows (running windows on a mac using parallels) and got this message. Much appreciate any help to resolve this
PROC IMPORT DBMS=accesscs Out=work.history1 REPLACE
TABLE= "tbldemoandmedhistory";
DATABASE= "\\.psf\Home\Dropbox (Partners HealthCare)\BWH Cardiac MR\Grants Application\PIZ\data_analysis\Results\Access Database\Final Release of db063009 - BH June 24 2014.mdb";
RUN;
Some questions to get things started and help narrow down the cause:
As @AndrewHowell said, can you see folder
\\.psf\Home\Dropbox (Partners HealthCare)\BWH Cardiac MR\Grants Application\PIZ\data_analysis\Results\Access Database
from your windows explorer?
Looks to me as if the leading dot in your hostname causes confusion in some part of the chain that resolves the UNC.
thanks everyone very much
It turns out I need to install PC file server and the problem resolved
many thansk
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.