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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.