Column name, table name in another table

Swapnil_21 — Wed, 03 Nov 2021 03:21:59 GMT

Hi,

Below is input table

Account_ID,Credit_Balance,Debit_Balance
8834,100,200
7456,200,500
7896,600,800
6543,700,900

Below is what I want

TABLE_NAME,COLUMN_NAME,ORIGINAL_VALUE,CHANGED_RANDOM_VALUE,DATE
HAVE,Account_ID,8834,1213,03-Nov-2021
HAVE,Account_ID,7456,4567,03-Nov-2021
HAVE,Account_ID,7896,6789,03-Nov-2021
HAVE,Account_ID,6543,9867,03-Nov-2021
HAVE,Credit_Balance,100,432,03-Nov-2021
HAVE,Credit_Balance,200,567,03-Nov-2021
HAVE,Credit_Balance,600,898,03-Nov-2021
HAVE,Credit_Balance,700,156,03-Nov-2021
HAVE,Debit_Balance,200,323,03-Nov-2021
HAVE,Debit_Balance,500,556,03-Nov-2021
HAVE,Debit_Balance,800,901,03-Nov-2021
HAVE,Debit_Balance,900,384,03-Nov-2021

How do I get this, changed value is actually a random number so values may differ. I am trying everything but somehow not getting the correct output. Any help is really appreciated

Re: Column name, table name in another table

SASKiwi — Wed, 03 Nov 2021 23:25:45 GMT

Please post your program attempt. It's hard to help if we don't know what you have tried.

topic Column name, table name in another table in SAS Programming

Column name, table name in another table

Re: Column name, table name in another table