Help using Base SAS procedures

Creating a Report Using Cases

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 90
Accepted Solution

Creating a Report Using Cases

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


Accepted Solutions
Solution
‎03-01-2012 04:51 AM
Super User
Posts: 10,044

Creating a Report Using Cases

Posted in reply to InfoAlisaA

maybe could like:

case

               when  maxvar=max(maxvar)

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

               else put(maxvar,best8.)

          end as Widest_Column

Ksharp

View solution in original post


All Replies
Solution
‎03-01-2012 04:51 AM
Super User
Posts: 10,044

Creating a Report Using Cases

Posted in reply to InfoAlisaA

maybe could like:

case

               when  maxvar=max(maxvar)

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

               else put(maxvar,best8.)

          end as Widest_Column

Ksharp

Frequent Contributor
Posts: 90

Creating a Report Using Cases

Posted in reply to InfoAlisaA

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 159 views
  • 0 likes
  • 2 in conversation