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

You most probably have an overflow error. The actual final value may not overflow, though.   One possibility is to calculate the logarithm of what you want first: log_GFR_CKEPI = log(101) +log(min((LBSTRESN/kappa),1))*alpha -log(max((LBSTRESN/kappa),1))+log(3.209) +log(0.88)*AgeAtLB +log(SEX_factor2)+ log(RACEO); GFR_CKEPI=exp(log_GFR_CKEPI);  That way, you can do the calculation, even if there is an overflow along the way - you will then only get an error message from the EXP function if the final value overflows. ... View more

Hi:   One way around having to specify values in the COMPUTE block is to use a user-defined format, as shown here:     I based the format on the first character of the name field in the SASHELP.CLASS file. The variable I created was called ALFA. Your format would have the dataset names and the colors you choose. I picked 4 colors. You could pick 2 different colors. In the PROC REPORT code, the ALFA column is a NOPRINT column, so it is available to be used, but does not display on the report. This kind of trafficlighting should also work in ODS EXCEL. Without any example data, it is hard to do more than make general suggestions.   Cynthia ... View more

Perhaps you have closed the tagsets.RTF destination? But we'd really need to see your code to be sure. In addition, you need to check the log for errors and warnings that might have an impact on this. ... View more

We can't help if the macro can't be shared. You should contact the author of 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