Macro for PROC REPORT to Meet Appropriate Comparisons

[turcay]

@Cynthia_sas,

Thank you very much. My real purpose was prevent this situation by using macro variables but as you said, it doesn't seem possible.

Thank you,

[Cynthia_sas]

Hi:
I didn't say it wasn't possible. I said you had to have working code for ALL possible types of HAVE files that you need to create. Without working code for ALL possible combinations, you do not know what macro variables or macro conditional logic to code. Given that amount of work, that is why Reeza and others have suggested that you use PROC SQL or some other process to get the data for your report structured the way you want and then use a much simpler PROC REPORT. Probably putting the work in to generate all the possible different combinations of PROC REPORT for ALL your HAVE file scenarios is ultimately the way to go but what if down the road you end up with HAVE6, HAVE7 and HAVE8, 3 new scenarios you didn't previously envision? You'll have to decide which approach is the best approach for the long term.

cynthia