SAS Query

Toffeeman — Thu, 29 Oct 2015 20:00:45 GMT

My original code:

%let customer = ('ABC','CDE');

data cust;

set cust;

if customer in &customer then discount = discount*0.1;

run;

Question:

I have put the customer info in dataset to avoid input manually into the program

dataset (dataset name: CUST)

customer

ABC

CDE

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.

Re: SAS Query

PGStats — Thu, 29 Oct 2015 20:54:42 GMT

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;

(untested)