Ok thanks a lot, all your answers truely help clarify things for me! Would anyone be aware of good document explaining how to optimize queries in SAS?
... View more
Awesome guys, great to have so many different answers! Thanks for the additional information PG, i am using Ksharp query but yours just gave me more depth for my analysis
... View more
Don't feel bad about 2 steps. I have lots of code where I pre-process data and use tabulate for display. I've even got code that takes tabulate output and massages it before using tabulate to make the final table because my clients want a certain look.
... View more
Add a few, ANYALPHA Function ANYDIGIT Function NOTALPHA Function NOTDIGIT Function And of course compress() plus lengthn(). Regards, Haikuo
... View more
