topic Finding length in SAS Programming

Finding length

deleted_user — Thu, 19 Feb 2009 02:20:40 GMT

Hi all,
In a detaset If I want to find out length of particular column in distinct and in descending order then how I will do this by using macro queries?
Please help me out.

Thanks

Re: Finding length

Flip — Thu, 19 Feb 2009 12:52:08 GMT

I'm not sure why you want it in a macro but if an SQL will do.

proc sql;
select distinct length() as varlong from
order by varlong descending;
quit;