@wlierman wrote: There are 165,000 contacts and most have one CCO that they are assigned to. There are a few (say 100) that have 2 CCOs because as I mentioned because a zipcode will be split between the CCOs. So of the 165K about 135K have a CCO - zipcode or county is missing. This is survey data so much of the data whether REALD or demographic will have some missing or incomplete responses. So my question is if I use the Coalesce statement in the query do I code a subsetting "if"condition in a data step before the query? I want a condition that catches the 100 or so obs (contacts) that happen to have two CCOs. Thank you for your help. Still have described one or more rules that tell us which "contact" might need the 2 CCO. Your example data does not show Zipcodes at all. And now you need to define exactly what is meant by "Zipcode will be split between CCO". Especially since you say Zipcdoes may be missing for up to 75% of the records. That tends to make it a poor decision variable.   Coalesce will never return two values. It returns the first non-missing in a list of values. So I don't get why you keep saying coalesce. The CATX function will do that. Have you tested it? You would need to provide more complete data as to why it is not appropriate. ... View more

Hi, thanks so so much for this, could be having a reference, material please. Thanks ... View more

Hi @ PeterClemmensen, Its actually the speed of programming. ... View more

Hi , this reminds me my first time to use Macro, I didn't understand the difference between %if -%then  and if- then kindly find my findings: 1. '%if-%then' can ONLY be used in the MACRO program (whether inside the DATA step, or outside) and 'if-then' is ONLY used inside the DATA step (whether MACRO or non-MACRO).    2.In the DATA step, you can use 'if alone to do logical comparison. But you can not use '%if alone. You also can not use '%else' alone without '%do; %end' pair.    3.'%if-%then' uses MACRO variables in logical expressions and can not refer to DATA step variables in logical expressions (you can not write: %if x=l %then %do; because x is not a MACRO variable), while 'if-then' can use MACRO variables or use DATA step variables in logical expressions.    4.'%if-%then' in MACRO determines what text should be copied to the input stack. When you use 'if-then' inside a MACRO (or non-MACRO), it does logical comparison to determine what DATA step statements should be executed.    Hope this helps, thanks@_el_doredo ... View more

Hi, @ChrisNZ, thanks for sharing , actually I thought SaS performs the multiplication of decimals as the normal way one can do multiplication, plus the way it stores the values, I have realized its very different ... View more

Hi: Thanks for this. Yes, Jane's book is very good and she explains the limitations very well. I'm not sure why you have added to a 13 year old posting, so if you have a new question, you might want to open a new thread in the Forum. Since 2007, we now have ODS EXCEL in addition to TAGSETS.EXCELXP. What Jane wrote is still true, page-breaking is really only guaranteed to work the way it is designed in "paged" destinations like RTF and PDF. ODS HTML, ODS TAGSETS.EXCELXP and ODS EXCEL are NOT paged destinations. The original question was about how to do the equivalent of the SKIP option in PROC REPORT and my code showed how to do that. Cynthia ... View more

Thanks so so much @ FreelanceReinhard, for the response ... View more