10-29-2015 04:00 PM
My original code:
%let customer = ('ABC','CDE');
if customer in &customer then discount = discount*0.1;
I have put the customer info in dataset to avoid input manually into the program
dataset (dataset name: CUST)
May i know how to read the customer name from the dataset? and work get the similar result as my original code.
Anyone can help? Please advise. Thanks.
10-29-2015 04:54 PM
Assuming you put your list of special customers in dataset specialCust, you can adjust their discount in dataset CUST with:
proc sql; update cust set discount = discount*0.1 where customer in (select customer from specialCust); quit;