BookmarkSubscribeRSS Feed
rykwong
Quartz | Level 8

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;


Screen Shot 2017-07-18 at 5.27.55 AM.png
4 REPLIES 4
AndrewHowell
Moderator

Some questions to get things started and help narrow down the cause:

  • Forgetting SAS for a moment, can your new "Windows on a MAC" access the network path to the MS-Access file?
  • What version of SAS did you install, and what did you have previously (including version and 32/64-bit)?
  • What version of MS-Office did you install, and what did you have previously (including version and 32/64-bit)?
ChrisNZ
Tourmaline | Level 20

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?

rykwong
Quartz | Level 8

thanks everyone very much

 

It turns out I need to install PC file server and the problem resolved

 

many thansk 

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 775 views
  • 0 likes
  • 4 in conversation