tom actually I have two datasets 1 . NewTravelplan               Cardnumber     travel_plan_id xxxxxx7828         4912 xxxxxx7828         5823 xxxxxx8623         4516 xxxxxx8623         5154 xxxxxx8623         5225 xxxxxx2134         4917 above dataset shows card number and travel_plan_id for the new travel plan customer has opted 2. Available_name. Cardnumber     travel_plan_name xxxxxx7828            travel3 xxxxxx7828            travel5 xxxxxx7828            travel6 xxxxxx7828            travel7 xxxxxx7828            travel9 xxxxxx7828            travel7 xxxxxx8623            travel1 xxxxxx8623            travel2 xxxxxx8623            travel9 xxxxxx8623            travel10 xxxxxx2134            travel4 xxxxxx2134            travel5 above dataset shows the available travel_plan_name which on the given card numbers. Now I have to assign the unique travel_plan_name  to  travel_plan which opted on the card. I hope you understand, what I mean to say. I need a travel_plan_name from available_name dataset to put in ... View more

thanx tom. but if dataset would be like this then?   A    B   C      1     1    1  <-------      1     1    2      1     1    3      1     2    1      1     2    2  <--------      1     2    3      1     3    1      1     3    2      1     3    3  <--------      2     4    1  <--------      2     4    2     2      4    3     2      4    4     2      5    1     2      5    2  <--------     2      5    3     2      5    4 basically I got stuck with many to many merge ... View more

I am getting a file from in which I am getting card number, transaction id as a variable. Each sevice has some starting date and some end date. I have to keep a track that only 10 service should activate at a time. for first time I have to assign service1 - service 10 in a round robin way. That I have done. Next time when I will get the same cardnumber and transaction id, I have update that with the previous record which I got from earlier file. That is also covered by me. I got stuck in condition where if a new record came with same card number but different transaction id then I have to put a service value which is not in earlier records. Their can be a multiple records for single card number in one file. please help me on this. ... View more

I have to explain this to you in detail. can you join me on social community like facebook. ... View more

Hi Reeza, This is some what difficult to explain for me. I works for a credit card company. I have to built a code in which I have to keep a track that for a single card a service can be applied 10 times only at a time ... View more

thnx for the reply, but this query will not help me... actually I works for the bank, and I have to put a query in a dataset which implies that, if account number is in accounts then table, then only account number will be added to the table on which I am applying my query. ... View more

Hi, As per my thinking, you are talking about PROC sort and the problem you are facing is may be defined length. First see the length of country variable,increase the length size and you will get the full country name. ... View more