sas

[nayab_shaik]

Hi Team,

i have two tables like 

table1

id  name  trasactioncode

1  ss       1223432

2  ac        3382168

3 aa        3456729

3 gf        0998755

table 2 column like

barcode coloumn 

how to assign  each customer wise unique barcode to table a

Advance thanks

[PeterClemmensen]

I don't understand this. Please sketch how your desired result looks

[PaigeMiller]

Please give a fuller explanation of your problem and the logic needed to create the output.

Also — DO NOT SKIP THIS STEP — please go back and change the subject line to a meaningful subject line for your post. Every post here is about SAS, we need a post that briefly describes the problem.

[ballardw]

---

@nayab_shaik wrote:

Hi Team,

i have two tables like 

table1

id  name  trasactioncode

1  ss       1223432

2  ac        3382168

3 aa        3456729

3 gf        0998755

table 2 column like

barcode coloumn 

how to assign  each customer wise unique barcode to table a

Advance thanks

---

Do you have a value in common between the two tables? If so tell us which it is. If not you will need to find another table that has  values in common with both tables that can provide the linkage information.

I suspect you need to the additional table that would have the Transactioncode and all of the items affected during that specific transaction.

You should also provide exactly how you expect the result to look for a given set of example data as I suspect that you have a varying numbers of barcodes related to each transaction.