How to count the max length of each column of a multiple tables at a time by their datatype as string in SQL or SAS SQL

I want to find out the maximum length of each column of a multiple table within the single query using SQL or SAS SQL. How can I get it?