Thanks for responding!. Here I can help you with clear understanding of my data and what I wanted to achieve. I’ve a table which have columns named PRODUCT_TYPE, COST. The values of PRODUCT _TYPE are clothes, footwear and I’ve created two custom category data items to give the count of column values for PRODUCT _TYPE as well sum of COST column. I was creating a dashboard to show the summary report. I already created some cross tabs based on some filters. In those crosstabs the row value I used was the overall count of PRODUCT _TYPE and for Frequency SUMMED value of COST Column. For All the crosstabs I assigned COUNT, Summed Value of COST column as data roles based on some filters. For instance in crosstab1 have values like this : COUNT Frequency SUMMED Count 300 21000 In crosstab2 have values like this : COUNT Frequency SUMMED Count 500 43000 The above values for crosstab1, 2 are based on some filters . Now I’d like to have another crosstab with those same values. Required crosstab: COUNT Frequency SUMMED Count 800 64000 The above values have come by adding 300+500 and 21k + 43k. Please let me know whether this is achievable or not. Thanks a ton!. Please let me know if this doesn’t help. ... View more

Could your code work if table T2 has this kinda data, if it doesn't may I know how to make it work.  data T2; input ItemNo :$10. (ItemC1 - ItemC5) (:$8.); datalines; A101 MRF:123 . . Ceat:789 . A100 MRF:098 . Ceat:453 . . B01 IRP:126 . . . CRO:670 B0101 IRP:309 CRO:012 . . . ; Same rules and same concept. ... View more

I used your datastep code which has merging in it.   Here I'm gonna post you the snapshots of my output and changes made to Table T1 to test your code.  As you can see the Table T3(T1) for the ItemNo A100 it has MRF & CEAT. Both the values present in Table T4 (T2) but the output table isn't showing CEAT in ItemC3 since it is present in ItemC3 of Table T4. Could please test it out from your side as well by changing values in T3(T1).      As you can see in Table T3 (T1) for the ItemNo A100, it has MRF & Ceat. Both the values present in Table T4(T2) but in the output table Ceat isn't showing in ItemC3 since it is present in ItemC3 of Table T4. ... View more

I've cross checked your code by changing values in Table T1. Here's the output what it shouldn't give. Data T1; Input ItemNo :$10. (ItemC1 ItemC2) (:$8.); Datalines; A101 MRF CEAT A100 MRF . B01 . . B011 IRP CRO ; Below is my output, here I just made changes in Table T1 and table T2 remained same. As you can see there are only two ItemNo's matched A100 and B01 . In my output it should only give MRF for A100 besides it has also given ceat which isn't present in Table T1 for A100 ItemNo. Likewise B01. I request you to please help me out on this. Thankyou!. Here's the snapshot of my output ... View more

Your code is just matching the T1 ItemNo with T2 ItemNo and providing values of T2 that doesn't match with T1 ItemC1, ItemC2 with T2 ItemC1 - ItemC10.  ... View more

Yeah, I tried to fix it but the code is just matching the T1 ItemNo with T2 ItemNo and providing values of T2 that doesn't match with T1 ItemC1, ItemC2 with T2 ItemC1 - ItemC10. ... View more

I'm very much thankful for responding. However, the output table what should look like is :  Obs ItemNo ItemC1 ItemC2 ItemC3 ItemC4 ItemC5 1 A100 MRF . CEAT 2 B01 IRP . . . . This is how my output should look like, if the value of ItemC1, ItemC2 of T1 matches with any column of T2 then, it should output those matched values in whatever place they exist in T2. ... View more

I really appreciate your help. However, your code is just only matching the T1 ItemNo with T2 ItemNo and providing the values of ItemC1 - ItemC10 of Table T2 and not looking for the match of T1 ItemC1, ItemC2 across ItemC1 - ItemC10 of Table T2.   Besides match of T1 ItemNo with T2 ItemNo, it should also have a match of T1 ItemC1, ItemC2 in any of the columns of Table T2 (i.e T2 (ItemC1 - ItemC10 )). Once both the Conditions have a match then it should output the values of Table T2 for those matches. I hope I'm clear with this. Thanks!.   ... View more

Thanks for your help. However, your code didn't provide me right results. ... View more

I've tried it but didn't work out.  Here's my code and please suggest me if I made any logical error here. Proc SQL; Create table xyz as Select * from T2 Inner join T1 On T1.ItemNo = T2.ItemNo And T1. ItemC1 IN ( Select T2.ItemC1 T2.ItemC2 T2.ItemC3 T2.ItemC4 T2.ItemC5 T2.ItemC6 T2.ItemC7 T2.ItemC8 T2.ItemC9 T2.ItemC10 from T2) OR T1. ItemC2 IN ( Select T2.ItemC1 T2.ItemC2 T2.ItemC3 T2.ItemC4 T2.ItemC5 T2.ItemC6 T2.ItemC7 T2.ItemC8 T2.ItemC9 T2.ItemC10 from T2); Quit; This code is causing me errors bcuz can we select more than one column in a nested SQL Query?. Please help me on this. Thankyou!. ... View more

Yes, I am but does that actually work?. ... View more

To put that output in a better way A100 for ItemNo of T1 matches with A100 for ItemNo of T2 AND MRF for ItemC1 of T1 matches with MRF for ItemC1 of T2 AND Ceat for ItemC2 of T1 matches with Ceat for ItemC3 of T2. Likewise the conditions should match.   Here values of ItemC1, C2 of Table T1 may found in any variables of T2 for instance, consider the above explanation Value for ItemC2 of T1 found in ItemC3 of T2. So, if any matches found fetch the values from T2 . Required Output : ItemNo ItemC1 ItemC2 ItemC3 ItemC4 ItemC5 upto ItemC10 A100 MRF . Ceat . . . . B01 MRF . . . Ceat . ... View more

Well, here's Data T1; Input ItemNo $10. ItemC1 $8. ItemC2 $8.; Datalines; A10 MRF Ceat A100 MRF Ceat B01 IRP . B011 IRP CRO ; Run; Data T2; Input ItemNo $10. ItemC1 - ItemC10 $8.; Datalines; A101 MRF . . Ceat . . . A100 MRF . Ceat B01 IRP . . . CRO B0101 IRP CRO ; Run; Output: The output table simply have to have the records of (Condition1 T1.ItemNo = T2.ItemNo )) AND ( Condition2 T1.ItemC1 = T2. (ItemC1 - ItemC10) ) AND ( Condition3 T1.ItemC2 = T2. (ItemC1 - ItemC10) ) ;. The output table should meet these conditions. Here Condition1 & 2 means Any value of ItemC1, ItemC2 of Table T1 matches with Any value of ItemC1 to ItemC10 of Table T2 then output the columns from Table T2 for those matched records. I hope I made this clear and if you still have doubts please let me know. Thankyou!. an example.  ... View more

I appreciate your help Harry but I've mentioned two conditions if you closely observe it.   ... View more