Help using Base SAS procedures

How to append to access table

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 114
Accepted Solution

How to append to access table

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?

Accepted Solutions
Solution
‎06-04-2018 09:58 AM
Super User
Posts: 23,776

Re: How to append to access table

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?

 

View solution in original post


All Replies
PROC Star
Posts: 1,836

Re: How to append to access table


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

Solution
‎06-04-2018 09:58 AM
Super User
Posts: 23,776

Re: How to append to access table

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?

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 164 views
  • 0 likes
  • 3 in conversation