Good day   I have a two dataset as shown below   dataset1 customer_name and sitecode (has 50000 observation unique on customer_name) sam 2430 nice 3401 jim 2030 holl 3540 and so on dataset2 sitecode and required_number_of_customer (this dataset show the site and number of customers required per site and not repeating and this dataset contains 800 observation all unique on site code) 2430 60 4020 10 3540 2000 and so on   the requirement is that i should create one dataset that is going to contain number of unique customers according to the observation required per site if the customer is selected to site 2430 should not be included on other site  also flag selected customers so they wont get selected on the next run   apologies i am new to SAS i currently dont have any code Your help will be highly appreciated   thanks    Regards   N   ... View more

Good day    have a list 20 of programs  Sales.sas Marketing.sas HR.sas   all these they have a common macro variable called currentReporingmonth i want to iterate through all of them to find and replace that variable with mon1_date9 and output another sas code with chagnes or file for example    Sales.sas -> Sales1.sas Marketing.sas -> Marketing1.sas HR.sas -> HR1.sas   Your help will be highly appreciated   Regards   N   ... View more