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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.