Question

Describe the concept of a master-transaction file relationship and explain some approaches you can use to update the master file.

Answer 1

Master File:Master file meant by which contains data of customers or employees or etc..Main data of system or application.master file contains data like id of customers and address,name,bio etc..

Transaction file:We can change data of master file and this change is called transaction.The data in this transaction files used to update the master files.

Some example of master records:

Payment Record:

key Customer Id

date

amount transferred

invoice

Status

Ordered Product Record:

key Order ID

date

Vendor account number

amount paid

due date

invoice

delivery agent id

How can update Master file:

For example in above example master file want update then substituting  new information in the transaction file for the old information in the master file.

Date set of Master file:

Id data salary

1 parts 13,000

2 person 21,000

3 parts 15,000

4 exec 55,000

5 18,000

Data set of Transaction file

Id data salary

2 22,000

3 sales 24,000

5 records

You want to apply above transaction file to master file to update master file.By writing below code we can update

DATA NEWREC;
UPDATE MASTER TRANS;
BY ID;
RUN?
PROG PRINT DATA=NEWREC
TITLE 'Updated Data Set - NEWREC';
RUN;

And the output as follows

Data set NEWREC (New Master file)
ID DEPT SALARY
1 PARTS   13,000
2 PERSON 22,000
3 SALES 24,000
4 EXEC 55,000
5 RECORDS 18,000

Thank You :-)