Hi,   Can you please share, how did you solved it, as i m looking for same thing.   Thanks, Sunil ... View more

PROC RANK would allow you to do ranking using "dense". I've never used "decode()" and just looked it up in the Oracle documentation. From what I understand this would require some post processing of the result returned by PROC RANK (so an additional PROC SQL/Data Step on the output of the PROC RANK procedure via an additional pass through the data). ... View more

Well that was like pulling teeth. Try asking whomever runs the jobs or look for documentation or try searching the metadata: SAS(R) Data Integration Studio 4.3: User's Guide ... View more