Creating a Report Using Cases

InfoAlisaA — Wed, 29 Feb 2012 23:52:56 GMT

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 — Thu, 01 Mar 2012 09:51:31 GMT

maybe could like:

case

when maxvar=max(maxvar)

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

else put(maxvar,best8.)

end as Widest_Column

Ksharp

InfoAlisaA — Thu, 01 Mar 2012 20:23:53 GMT

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

topic Creating a Report Using Cases in SAS Procedures