Sql/SAS small project
Budget: ₹1,500 – ₹12,500 INR
I have a set of customers with following columns:
Account number
Customer Id
Flag
Pan number
Reason
Flag can be X or Y. Other 4 columns could have any values. Multiple Customer Ids can have same Pan number
Problem statement is that I have to create another column against accounts where reason is "xyz" and fetch the customer ID for those accounts where Flag is X, in the new column created.
Need a code which will work in SAS enterprise guide 8.3
Please refer to the image attached to understand the problem better
Account number
Customer Id
Flag
Pan number
Reason
Flag can be X or Y. Other 4 columns could have any values. Multiple Customer Ids can have same Pan number
Problem statement is that I have to create another column against accounts where reason is "xyz" and fetch the customer ID for those accounts where Flag is X, in the new column created.
Need a code which will work in SAS enterprise guide 8.3
Please refer to the image attached to understand the problem better