HI Reeza,   Thanks for your reply and here I need a mcro because I have to use this logic to most of my programmes . That is the reason I asked a macro for this ... View more

I want to call the macro like this   &lob   as        LOB cd_claim  as claim    and then the LOB should show wether the claim is CI or PI   ... View more

The output should show   Proc sql; create table base as &LOB as LOB,claim_id as claim ettc..       The LOB column should show wether this claim is PI or CI   So that The LOB macro variable should fetch claim from the PI table and look up  the claims from other tables .   In simply lob=  The claims from PI table is matching with the claims from other table then PI else CI   Regards,   Manesh     ... View more

HI Riza,   Sorry to bother you again on this . I think my explanation was not enough to help me for this . Actually i am working for insurance claims reporting which deals with commercial insurannce(CI) and personal Insurance (PI) . we have one perticular table to identify the PI claims and there now I want to create a macro which should identify if one claim is PI or CI . I tried the below code .   %lob_div= case Proc sql;select CL_claim_PI from PI_table then PI else CI end;   The business logic is if the claim id for one poliy is available in the PI_table then it is PI elase CI . so I need to extract the PI claims from the PI table and check if this claim is available in the other tables and ten it is PI elase CI     Jus need to differentiate these two to create a report . I just want to show the LOB_DIV (Line of business wether it is CI or PI) in the report   Thanks   Manesh   ... View more

Hi Team,   My client needs an additional column in the report to identify wether the insurace claim is Personal (PI) or Commercial (CI) . To identify the PI claims we have one PI claims table and If i want to fetch the PI claims only I can do with SQL joins . But here I need to create a macro with the PI claims from the PI_Table and use in to the code which i have . It should be taking all the PI claims from PI table and create a maco call routine . Thanks   Manesh           ... View more

Hi I need a macro to identify this ... View more

I have created one macro variable and trying to extract from one databse giving condition as where clm_id in ( &clm. ) since the &clm macro var is empty getting a warning message apparent symbolic reference clm  not resolved ... View more

Hi Linush,   Thanks for the reply . I just want to know how in the background (PDV) it works .    what is in= ?   how it works?   Thanks    Manesh ... View more

Hi the below definition you provided is correct   B = more than 1 record for the ID, and total of all SYS_AMOUNT is equal to ACTUAL_AMOUNT   N = just 1 record for the ID, and SYS_AMOUNT equals ACTUAL_AMOUNT   R = just 1 record for the ID, and SYS_AMOUNT does not equal ACTUAL_AMOUNT   If there are multiple ids then sys_amount and Actual_amount will be equal always .   Only need to get the above three rules.   Thanks ... View more