HI Cynthia,   Thanks a lot for your inputs.   I will give what exactly my requirement is,   1. I have a data set with 100 subjects and 5 variables. 2. For each subject I have to display a separate RTF file with the actual data as per data set in the format that you gave in the     previous reply. Also For ex: if there is any field, lets assume 'Start date' is one of the fields and for a specific subject start date is       Null, we should not get that row at all in the rtf file. 3. At last, I have another Excel input where we get reviewer comments in it in a single cell and it could be very lengthy. I have to    append those comments to the respective RTF file subject wise with a neat text alignment and borders to it (Comments should be With in a BOX at the end of the RTF file for each subject with proper format).     please help me on this requirement.   Thanks, Hari ... View more

Thanks for reply.   I am writing some data (specific columns for each subject which are fetched from a dataset into macro variables) already through PUT statement into a external RTF file.    At last I have to append Comments (This value I will fetch it from a different file into a macro variable). I am trying to write the value from a macro variable using PUT statement after all columns printed through put statements as mentioned above. for comments value, I need to display with proper alignment with in a box, just to look good. Now since comments value is a lengthy statement and its not getting displayed properly in the RTF file.   as you mentioned, we may try to display the macro variable with in TITLE/FOOTNTE statement with styles applied to it. please suggest how can we do this.  Just assume a macro variable with lengthy single statement in it as a value and we have to write to a RTF file and the value should be with in box.   Please consider &comm. has the value, you can see Put "&comm."; in the code below.     　 %MACRO AEDATA(); %DO i=1 %to &total.;   data _NULL_; file "XXXXXXXXX\testf&i..rtf" print  ;   Title; put ' '; put ' '; PUT 'SUBECT ID :' "&&sub&i."; %IF %sysfunc(length("&&aetrm&i.")) > 2 %then %do; put 'AE Term is :' "&&aetrm&i."; %end; %IF %sysfunc(length(&&llt&i.)) > 0 %then %do; put 'AE Llt is :' "&&llt&i."; %end; put 'Start date is :' "&&stdt&i."; put '*************************'; put '*************************'; put '*************************'; put '*************************'; put "&comm.";   run; %END; %MEND;   %aedata;         ... View more

Hi, This works but the challenge is sas will still execute statements outside macro/step which are written after. This should not happen.    endsas option is working for me. thanks for your suggetion. ... View more

Hi Sir,   I tried this too. It's a direct code or through #include, the challenge is sas was executing rest of the code after macro. I dont want that to happen because once I find any error in any step sas should not execute any statements furthur.   Now finally some how I am able to do it using endsas itself.   Thanks for your suggetions. ... View more

Thanks you Sir.   but this is not what I am expecting. In my actual code, I will have many other data steps outside of Macro and I should not execute any of them when  a certain conditon with in that macro is satisfied. please check again and revert. ... View more