Creating a Report Using Cases

[InfoAlisaA]

Hello Everyone,

I am working on this problem where I need to have an * by the highest value in a report.

This is my original code:

proc sql flow=6 35;

title 'Orion Library Table Information';

   select memname, nobs label='Rows', nvar label='Columns', filesize label='File Size', maxvar label='Widest Column'

          from dictionary.Tables

   where libname="ORION" and

         memtype ne 'VIEW';

I tried to create a case for the maxvar that was:

         case

               when max(maxvar)

                 then catx('',maxvar,'*')

               else maxvar format

          end as Widest_Column

However, I got the following error when I tried to do that:

Result of WHEN clause 2 is not the same data type as the preceding results.

I am not sure how to do this, but if anyone can help me with this, it will be greatly appreciated.

Thanks!

Alisa

[Ksharp · Accepted solution]

maybe could like:

case

               when  maxvar=max(maxvar)

                 then catx('',maxvar,'*')

               else put(maxvar,best8.)

          end as Widest_Column

Ksharp

[InfoAlisaA]

Awesome! Thank you so much! That worked out! :smileygrin: