@Shantaram wrote: I have to pass value from (put '<value>' &DC_ID. '+(-1) </value>';) here. instead if &DC_id. i have to pass column value to the macro. ok, I think what you want is this: (replace -100 / 100 with the value needed %macro file_loop(DC_ID,addValue); if &DC_ID. ne . then Do; put '<answer>'; &DC_ID.=&DC_ID.+&addValue.; put '<value>' &DC_ID.'</value>'; put '</answer>'; End; else Do; put '<answer>'; put '<value/>'; put '</answer>'; end; %mend file_loop; options mprint mlogic symbolgen; data _null_; set transformed_data; file "$test/DB/TEST_test1.xml"; if _n_=1 then do; put '<?xml version="1.0" encoding="UTF-8"?>'; put '<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:type="http://www.quinity.com/qis/soap/qisxmlpolicyrequestservice/type">'; put '<soapenv:Header />'; put '<soapenv:Body>'; put '<handlePolicyApplicationRequest>'; put '<policyRequest>'; Put '<applicationForm>'; Put '<applicationFormGroupList>'; put '<applicationFormGroup>'; put '<formGroupRef>'; put '<externalIdentifier>PolicyDate</externalIdentifier>'; put '</formGroupRef>'; put '<applicationFormQuestionList>'; put '<applicationFormQuestion>'; put '<formQuestionRef>'; put '<externalIdentifier>Policy</externalIdentifier>'; put '</formQuestionRef>'; %file_loop(DC_01,-100); put '</applicationFormQuestion>'; put '</applicationFormQuestionList>'; put '</applicationFormGroup>'; put '<applicationFormGroup>'; put '<formGroupRef>'; put '<externalIdentifier>Prod</externalIdentifier>'; put '</formGroupRef>'; put '<applicationFormQuestionList>'; put '<applicationFormQuestion>'; put '<formQuestionRef>'; put '<externalIdentifier>ProdName</externalIdentifier>'; put '</formQuestionRef>'; %file_loop(DC_02,100); put '</applicationFormQuestion>'; put '</applicationFormQuestionList>'; put '</applicationFormGroup>'; put '</applicationFormGroupList>'; put '</applicationForm>'; put '</policyRequest>'; put '</handlePolicyApplicationRequest>'; put '</soapenv:Body>'; put '</soapenv:Envelope>'; end; run; ... View more