How to append to access table

[Gil_]

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?

[novinosrin]

---

@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?

[Reeza · Accepted solution]

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?

---