topic Re: How to append to access table in SAS Procedures

How to append to access table

Gil_ — Thu, 03 May 2018 21:37:55 GMT

I have a data set I need append to access table
Here is my script..
Libname test 'j:\prod\database. Accdb';
Proc append base=test data =dep;
Run;

My question how do I refer the name of the table where I want it to append to?

Re: How to append to access table

novinosrin — Thu, 03 May 2018 21:40:52 GMT

@Gil_wrote:
I have a data set I need append to access table
Here is my script..
Libname test 'j:\prod\database. Accdb';
Proc append base=test data =dep;
Run;

My question how do I refer the name of the table where I want it to append to?

Base= should be the dataset where you want your data=dataset to append to.. In your example, is test a dataset or libname?

Re: How to append to access table

Reeza — Thu, 03 May 2018 22:31:38 GMT

Test is the full access DB, it would be test.AccessTableName.

@Gil_ wrote:
I have a data set I need append to access table
Here is my script..
Libname test 'j:\prod\database. Accdb';
Proc append base=test data =dep;
Run;

My question how do I refer the name of the table where I want it to append to?