Hi,   I have a large dataset containing distances of different stores to a customer. My dataset looks something like this: Customer_ID     Retail_Store_1       Retail_Store_2          Retail_Store_3         Closest_Store 1234                     0.56                           0.78                         3.1                        Retail_Store_1          I am trying to split this dataset into 3 datasets for each retail store. I want to split by closest store and Retail_Store_# < 10 miles. I used the obs=1000 to limit it but it is affecting my where clause. There are scenarios where the dataset is less than 1000 and I want to add more records to it. I want to check the remaining records in the original dataset and check again for the closest store and less than 10 miles until count reaches 1000 or there is no more records left.   Below is my code to search for the closest store: %macro find_closest_store(county, numrows); %let county = &county; %let numrows = &numrows;   data closest_store; set &county.data array Retail_Store(&numrows) Retail_Store_1-Retail_Store_&numrows; &county._min_value=min(of Retail_Event(*)); closest_store=vname(Retail_Store(whichn(&county._min_value, of Retail_Store(*)))); run; %mend find_closest_store; %find_closest_store(county1, 10);   My code for split (I had a macro but it was a long code so I just took a piece of it)   proc sql; create table county_Retail_Store_1 as select from county_data (obs=1000) where closest_store = 'Retail_Store_1' and Retail_Store_1 < 10; quit;   However, this obs statement is throwing off the where clause and I am getting results for distances > 10 as well.   These are the steps that I want to take but I am running into issues.   Assign the closest store to each member. (I did that successfully) Split the event data per the closest store but limit the count to 1000 (need help with this - not getting good results) If less than 1000, search for more members if available and calculate the closest store again and if within 10 miles of the desired store, add those members until it reaches 1000 or no more records left.   (Need help with this as well). Any help will be appreciated.   Many Thanks! ... View more

Hi,   I want to know if it's possible to find all addresses within a certain mile radius of an address (For instance, 123 Random St, City, 12345). I just want to find any address that falls within a certain mile radius of an address. I do not have any list of addresses that I want to get a match on (and that's not what I'm looking for).    Also, if there is a list of all US address stored in a SAS library. Maybe I could use that to match it against my address. I am not certain if there is one.    Thanks for the help! ... View more

I want to convert a sas date to Teradata date in the where clause below:   Sample code:   proc sql; create table temp_4 as select a.counter, max(c.ID) as CI_ID from temp_3 a left join table.abc b ON a.H_ID = b.X_ID inner join table.def c ON b.CI_ID = c.CI_ID left join table.ghi d ON c.CI_ID = d.CI_ID where b.type ='HI' and substr(c.CI_LAST_NM,1,12) = a.Surname and substr(c.CI_FRST_NM,1,7) = a.First_Name and c.CI_BIR_DT = a.DOB and c.CI_SEX_C = a.gen group by a.counter  ; quit;   c.CI_BIR_DT = a.DOB CI_BIR_DT is a Teradata date and a.DOB is the sas date. I tried a few options but failed to get the correct result. Please advise.   Many Thanks!       ... View more