topic Re: sas in SAS Programming

sas

nayab_shaik — Tue, 28 Jan 2020 10:34:09 GMT

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

Re: sas

PeterClemmensen — Tue, 28 Jan 2020 10:36:41 GMT

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

Re: sas

PaigeMiller — Tue, 28 Jan 2020 11:52:03 GMT

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.

Re: sas

ballardw — Tue, 28 Jan 2020 15:46:33 GMT

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