Hi All, I am trying to write if condition inside first if condition. Sample code. data transformed_data; input DC_014 $6. DC_019 $13. DC_035 $9.; cards; 116312 tosst po&ice 118323 tosst Police Mobile 113244 tosst Police Mobile 115333 tosst Police Mobile 118333 tosst Police Mobile ; run; %macro file_loop(DC_ID); if &DC_ID. not in('.',' ') then Do; if compress(&DC_ID., '% <>&', 'k') in ('&') then Do; put '<![CDATA['; put '<answer>'; put '<value>' &DC_ID. +(-1) '</value>'; put '</answer>'; put ']]>'; End; else Do; put '<answer>'; put '<value>' &DC_ID. '</value>'; put '</answer>'; end; End; else Do; put '<answer>'; put '<value/>'; put '</answer>'; end; %mend file_loop; options mprint mlogic symbolgen; data _null_; set transformed_data; file "c:/TEST_Shan1.xml"; if _n_=1 then do; put '<?xml version="1.0" encoding="iso-8859-1"?>'; 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>'; /*Code*/ Put '<applicationForm>'; Put '<applicationFormGroupList>'; put '<applicationFormGroup>'; put '<formGroupRef>'; put '<externalIdentifier>polGenStartdate</externalIdentifier>'; put '</formGroupRef>'; put '<applicationFormQuestionList>'; put '<applicationFormQuestion>'; put '<formQuestionRef>'; put '<externalIdentifier>Pol1</externalIdentifier>'; put '</formQuestionRef>'; %file_loop(DC_014); put '</applicationFormQuestionList>'; put '<formQuestionRef>'; put '<externalIdentifier>pol</externalIdentifier>'; put '</formQuestionRef>'; %file_loop(DC_019); put '</applicationFormQuestionList>'; put '<formQuestionRef>'; put '<externalIdentifier>pol</externalIdentifier>'; put '</formQuestionRef>'; %file_loop(DC_035); put '</applicationFormQuestionList>'; put '</applicationFormGroup>'; put '</applicationFormGroupList>'; put '</applicationForm>'; put '</policyRequest>'; put '</handlePolicyApplicationRequest>'; put '</soapenv:Body>'; put '</soapenv:Envelope>'; end; run;
... View more
