DATA Step, Macro, Functions and more

Finding length

Reply
N/A
Posts: 0

Finding length

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
Super Contributor
Posts: 359

Re: Finding length

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;
Ask a Question
Discussion stats
  • 1 reply
  • 110 views
  • 0 likes
  • 2 in conversation