I edited my last post according to your advices. I hope to be been clearer now... Answering to your question, I'd like no output for the criteria I choose beacause I have to produce about 100 ds of output and I want to discard those where the intersections do not exceed a certain threshold. Thanks, D ... View more

Try reading this article: http://blogs.sas.com/content/iml/2015/07/29/or-plots-log-scale.html for me it was very useful.   Daniela ... View more

Use formatted input with the TIME5. informat for this variable, i.e., replace "TIMEVAR $ 10-14" by "TIMEVAR time5.". You can then apply the TIME5. format to TIMEVAR for display purposes. ... View more

Hi:   I don't understand what you're asking. Using DDE is not going to work with PROC TABULATE unless you create an output dataset. Did you look up the CLASSLEV statement??? You already use a STYLE= statement level override with your CLASS statement:      CLASS sex /style={just=r};   So you merely have to look up and then use a CLASSLEV statement. For example, for AGE:     CLASS sex age / style={just=r};  <--- added AGE here, so you can see both headers are right-justified     CLASSLEV age / style={just=c};  <--- shows that the VALUES or LEVELS for AGE are center-justified separately from the HEADER label. produces this: cynthia ... View more

Hi:   I am not sure you can get ODS to use a '.' instead of a space, but you can use the sheet_name and sheet_label suboptions to have some control over the table. Switching your code to SAS Macro might be one approach. I am not sure whether you can change the tagset template for ExcelXP to alter the way it makes sheet names or not. That would be a question for Tech Support. cynthia ... View more