Yes there are different values in the paramcd but for the one condition there are two instances and if start date of ttadjcvd equal to the startday of the ttdeath then I need to change the data of ttdeath to ttadjcvd ... View more

I guess this is due to big constant number.Can we rectify this? ... View more

@PaigeMiller  I have 15 +datasets in the dataset column. Bi -colouring means just two colours simultaneously to differentiate the datasets visually. For instance, the first adam dataset is in grey, the second in white and repeating. Here, macro means this is for one study and I would like to apply this for every study so,we cannot fix dataset number(every study varies).For instance,leave macro topic. If we get solution for one study also fine.Looking for the options to get the output in desired way. Sorry for attaching the screenshot I am unable to explain you clearly without the image.   ... View more

Hello @PaigeMiller ,   Thanks for the quick response.   Actually, I have datasets, variable, length, label as the variable names. I have many datasets in the datasets column .I cannot give style option manually. So, I am looking for any default options which i can put inside the macro.                                   ... View more

Hello @Cynthia_sas   My issue got resolved by using column option and using ods rtf columns=max statement.   Thanks for your help.   Sahithi ... View more

Thanks for your time everyone. Inputs from @Cynthia_sas and @ballardw helps me to get the desired output. ... View more

@ballardw , As suggested,I have checked by giving ods rtf columns=4 statement yes it is working now need to change the font settings of the column headers.   Thank you so much for investing your valuable time   ... View more

@ballardw,   Front page is just related to title of the project and basic demographic data in a table.I don't want front page output and final output in a single page.I need output in 2 pages one is front page another is the actual output. So, here space left after creating "Front page" doesn't matter I guess.   Please find my code: options nodate validvarname=any; ods rtf file="&out.\&a..rtf"; proc report data=front_page noheader center; run; ods escapechar='^'; ods text=" "; ods text="^S={color=red width=100% just=c}xxxxxxxxxxxxxxx"; options papersize=letter topmargin=.5in rightmargin=.5in leftmargin=.5in proc report data=final style(report)={cellpadding=3px} style(column)={font_size=8pt}; column order spid; define order /display "xxxxx to select the xxxxxxxx" STYLE (HEADER) = {JUST=C CELLWIDTH=10%}; define spid /display "xxxxxxxx xxxxxx from the xxxxxxx list of the xxxx" STYLE (HEADER) = {JUST=C CELLWIDTH=10%}; run; ods rtf close; Here for getting desired output i need to give column=2 in the ods statement before final dataset's proc repport.If I write the ods statement there I don't get two outputs in the same file. ... View more

Hello @Reeza ,   Actually I need to display front page along with this output.As of now I am just giving only one ods rtf statement for both but now i don't want to apply column=2 options in the front page .So, I need to write another ods statement for this. Is this possible to get both ods outputs in the same file??   Thanks for your time ... View more

Thank you so much @Cynthia_sas for your explanation.The output which you are getting is my desired one. But, here I have front page also to display but i don't want column=2 option there and need to print both outputs in the same file. As of now I am just giving only ods rtf to the both reports if i need to give column=2 option then I need to write another ods rtf statement for my final data but how can I print both outputs in the same file? Hope you understand my query here. ... View more