DATA Step, Macro, Functions and more

SAS Query

Reply
Occasional Contributor
Posts: 14

SAS Query

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.

Respected Advisor
Posts: 4,919

Re: SAS Query

Posted in reply to Toffeeman

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)

PG
Ask a Question
Discussion stats
  • 1 reply
  • 136 views
  • 0 likes
  • 2 in conversation