I know that there is a discussion on this topic (, but I can't seem to be able to figure out the final product. Does anyone have a documented process for accomplishing this task? I tried the following without any luck:
libname TAP2015 'C:\Users\V\Desktop\TAPDB_For SCRR\TAP Jan 2015';
%let dbname = C:\Users\V\Desktop\TAPDB_For SCRR\TAP Data Bi-annual end dec 31 2014\TAPData_1_12_2015.mdb;
%let tablelist = ABCProgramType
ActionItemDisposition
ActionPlan
ActionPlanType
Activity
AgeGroup
ApAssessmentTool
ApProgramSize;
%let filename = ABCProgramType;
proc import out = TAP2015.&filename
datatable = "&filename"
dbms = access replace;
database = "&dbname";
run;
Thank you for your time.
Without any luck
If there were errors it would help to post them.
If the results were not as expected describe the unexpected results such as not all tables imported, only one, variables not of expected type or some detail.
I received the following error message:
ERROR: Unable to open file C:\Users\V\Desktop\TAPDB_For SCRR\TAP Data Bi-annual end dec 31 2014\TAPData_1_12_2015.mdb. It does not
exist or it is already opened exclusively by another user, or you need permission to view its data.
If you have opened the database then MS Access locked it and you can't use this method.
Or double check the exact name and path, once in awhile a not-obvious space creeps into a path:
TAPDB_For SCRR or
TABDB_For SCRR <= 2 spaces
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.