Good morning,
With SAS9.3 i used to import an Access table using the following syntax:
PROC IMPORT OUT= TB_KEY (keep=R_fPatient DDN Sexe N_Adm
rename=(N_Adm=ADMINO)
)
DATATABLE= "TbPatient"
DBMS=ACCESSCS REPLACE;
DATABASE="\\Sih-fs\programmes\CPTCR\BD_CPTCR.mdb";
SCANMEMO=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;
Since upgrading to SAS 9.4, this syntax is not working anymore and I cannot access the database anymore.
Can you please help me?
I cannot provide a sample as it is patient confidential data.
Thanking you in advance,
Aline
If the PC Files Server is not installed on the same machine where the SAS process runs, you need to supply at least a server name to the import procedure if you use dbms=ACCESSCS.
From the 9.3 documentation of ACCESSCS for PROC IMPORT:
SERVER= PC-Files-Server-name
I am going to assume this is a 32/64 bit problem. Basically when Windows moved to 64bit, a lot of the proprietary binary files no longer worked - including SAS catalogs. There have been some suggestions made like using PCfiles. However I am of the opinion that this is a really good time to bin these dreadful, archaic file types in favour of far more open, portable sources. For instance, dump out your data from Access into a CSV file - CSV is plain open text, which will work on any system and is not tied to a proprietary format.
If you absolutely have to use Access (why?), then you will need to migrate that file and software to 64bit to match the bit of SAS you are using or setup an export process from it to an open file format. Me I would not be using any Office software as a data store, invest in a proper database, or use a proper method of data transfer, I cannot express how much of an issue Office suite is in the world.
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.